XL97: How To Standardize Format Among Sheets with Varying Formatting In A Single Step

L

leojbramble

Ok, I know I'm reaching here, but does anyone by any chance know how t
standardize one parameter and leave the others, e.g., change all sheet
from A4 size to letter size, but at the same time maintain the varyin
portrait/landscape orientations among the various sheets
 
F

Frank Kabel

Hi
only possible with VBA and cycle through all sheets. So soemthing like

sub foo()
dim wks as worksheet
for each wks in worksheets
with wks.pagesetup
.footer="Test"
end with
next
end sub
 
Top