Thread: Running a one macro on all sheets within the file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] johnhildreth@citynet.net is offline
external usenet poster
  
Posts: 43
Default Running a one macro on all sheets within the file
Loop through the sheets using something like:

For i = 1 To Worksheets.Count

'Your code here

Next i

HTH,
John

Reply With QuoteReply With Quote