A
A C
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
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