Hello there,
I am using microsoft excel 2003 and in the VBA editor,
For formatting the sheet for printing on a single page,
I am supposed to make use of Worksheets("Sheetname").Pagesetup property.
In my VBA editor, I am not able to find the pagesetup property.
Could you please help me on this….
Please find enclosed the snapshot depicting the same.
Could you please help me whether, I need to add any reference
Thanks in anticipation ….
Gord Dibben - 29 Dec 2006 18:37 GMT
Renuka
Highlight "pagesetup"(no quotes) in your code then hit F1
Should get a help page with examples of usage.
Gord Dibben MS Excel MVP
>Hello there,
>
[quoted text clipped - 10 lines]
>
>Thanks in anticipation
.