PageSetup doesn't work

C

Chrigu

I checkt the code, everything works when i check with F8. But the
Header is not changed...

dim wks as worksheet
for each wks in thisworkbook.worksheets
wks.PageSetup.RightHeader = "HeaderRight"
next wks

Thanks for your help!
 
J

Jim Cone

It works for me in xl2003. Couple of notes...
A worksheet must have some data on it in order to preview it.
If "HeaderRight" is a variable, then remove the surrounding quote marks from it.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(remove unused styles or number formats - it's in the Free folder)




"Chrigu" <[email protected]>
wrote in message
news:9180aaeb-3d1a-4569-9f4e-31160ba26327@f20g2000vbc.googlegroups.com...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array to specific worksheet - nothing seems to work 2
Stubborn array wont change destination worksheet - HELP! (reposteddue to incorrect formatting) 2
renaming tabs based on a on a worksheet 2
Filtering Worksheets by Same Criteria - Object variable or with blockvariable not set 5
help with code 1
Protection Macros--modify to allow format changes 2
Inaccurate count with code 6
Copy a table from one workbook to ALL worksheets in a different wb 1

Top