View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default Run Macro on All Sheets Q

wrote:
I have a macro that runs a routine on the active sheet,
but how would I create a macro that will run this macro
on 'all' sheets expect sheet1 & sheet4?
I would prefer to create a new macro and call the original
macro from within, so that I have the option to run individually


Sub looper
Dim ws As Worksheet
For Each ws in Sheets
ws.Activate
call originalMacro
Next
End Sub