Hi

Can someone tell me how to correctly copy the PageSetup properties from 1
worksheet to another. I would like to copy every property over but dont
want to write code listing every single property, I would like to do it
"automatically" in the code.

For example, will the following work properly?

myNewWorksheet.PageSetup = myOldWorksheet.PageSetup


Or is there a way to loop over the pageSetup properties?
eg
for each ??? in PageSetup
myNewWorksheet.PageSetup.???? = myOldWorksheet.PageSetup.???
next ???


Thanks
A