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.
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.