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

Giganews Newsgroups
Subject: Excel BUG (All Versions) Excel Macro Margins using Print Preview
Posted by:  GP (…@dummy.it)
Date: Sat, 25 Oct 2003

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.

Replies