Excel BUG (All Versions) Excel Macro Margins using Print Preview

G

GP

Where can i post this BUG? (Excel Macro Margins using Print Preview)
Is there an Excel BUG reporting site?

Steps:
1) New worksheet, write something in it
2) Start recording a new macro
3) File -> Print Preview
4) Click on the Margins Button, the page margins will appear, so that you
can visually change and move them
5) Set one or more margins
6) Close the Print Preview
7) Stop the Macro

What happened is that in the VBA code there will be writtenthe following
lines:

..LeftMargin = Application.InchesToPoints(0.91)
..RightMargin = Application.InchesToPoints()

Where in second line there is a syntax error because there are no arguments
into the brackets.
This is why Excel does not record any single visual changement of the
margins
in the Print Preview, but takes a snapshot of the changes, so that all the
margins
are recorded, also those that were not changed, resulting in a blank
argument.
 
R

Rasp

Yes, also Excel 2003 seems to have this bug.
I looked in MS site, but find no bug-reporting page, sorry!

Enzo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top