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()
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()