Thread: Macro to Select All Sheets and Make Change to Footer
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karin Karin is offline
external usenet poster
  
Posts: 125
Default Macro to Select All Sheets and Make Change to Footer
Hi, I need help with this code, please. I want to select all the sheets in
one workbook and change the right footer to nothing, then select the A1 on
the first worksheet. What am I missing? Thank you!

Worksheets.Select
PageSetup.RightFooter = ""
Sheets(1).Select
Range("A1").Select

Reply With QuoteReply With Quote