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

  • Thread starter Thread starter leojbramble
  • Start date Start date
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
 
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
 
Back
Top