Thread
:
Run Macro on All Sheets Q
View Single Post
#
6
Posted to microsoft.public.excel.programming
Gord Dibben[_2_]
external usenet poster
Posts: 621
Run Macro on All Sheets Q
Sub looper()
Dim ws As Worksheet
For Each ws In Sheets
If ws.Name < "Sheet1" And ws.Name < "Sheet3" Then
ws.Activate
Call Original Macro
End If
Next
End Sub
Gord
On Fri, 30 Aug 2013 12:40:13 -0700 (PDT),
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
Reply With Quote
Gord Dibben[_2_]
View Public Profile
Find all posts by Gord Dibben[_2_]