uktous
03-24-2013, 12:15 AM
My home computer used Excel 2007.
When I run the code below, the margin become 2.5.
My office computer used Excel 2003.
When I run the code below, the margin become 1.
1 inch = 2.54 CM
Sub
ActiveSheet.PageSetup.LeftMargin = Application.InchesToPoints(1)
End Sub
The problem is that my office computer can read the code with correct unit (inch)
But My home computer read the code with wrong unit (cm).
How can I use Excel VBA to fix this with Excel 2003?
Thanks
When I run the code below, the margin become 2.5.
My office computer used Excel 2003.
When I run the code below, the margin become 1.
1 inch = 2.54 CM
Sub
ActiveSheet.PageSetup.LeftMargin = Application.InchesToPoints(1)
End Sub
The problem is that my office computer can read the code with correct unit (inch)
But My home computer read the code with wrong unit (cm).
How can I use Excel VBA to fix this with Excel 2003?
Thanks