Excel BUG in macro recording (every version)

  • Thread starter Thread starter w
  • Start date Start date
W

w

I have found a bug in every Excel version, where can i post it?

1) Start recording a new Macro
2) Go to Print Preview
3) Adjust a margin
4) Stop recording

The macro contains errors because it has empty parameters for the margins:

With ActiveSheet.PageSetup
.LeftMargin = Application.InchesToPoints(0.84)
.RightMargin = Application.InchesToPoints()
.TopMargin = Application.InchesToPoints()
.BottomMargin = Application.InchesToPoints()
.HeaderMargin = Application.InchesToPoints()
.FooterMargin = Application.InchesToPoints()
 
w

From XL2003

..LeftMargin = Application.InchesToPoints(0.78740157480315)
..RightMargin = Application.InchesToPoints(0.78740157480315)
..TopMargin = Application.InchesToPoints(0.78740157480315)
..BottomMargin = Application.InchesToPoints(0.78740157480315)
..HeaderMargin = Application.InchesToPoints(0.590551181102362)
..FooterMargin = Application.InchesToPoints(0.590551181102362)

I cannot test earlier versions as I don't have them, but I suspect it is
only recording the change. I changed all of them for the above.
 
Which way did you change the margins? Graphically from the Margins
button, or numerically from the Page Setup button? In 2000 and XP, the
graphic approach fails to record values that were not changed, resulting
in code that will not run.

Jerry
 
Graphically, if i set the margins manually it works, but if i do it from the
preview
every excel version (2003 as well) has this bug.

Elio



----- Original Message -----
From: "Jerry W. Lewis" <post_a_reply@no_e-mail.com>
Newsgroups: microsoft.public.excel
Sent: Sunday, October 12, 2003 1:25 PM
Subject: Re: Excel BUG in macro recording (every version)
 
Back
Top