Cycle thru worksheets in a workbook

  • Thread starter Thread starter June
  • Start date Start date
J

June

How do I bring each sheet in a workbook to Active? I have
a formatting macro I need to run on each sheet.

Thanks in advance!
June
 
Hi

you couls try something like



Dim ws As Worksheet

Application.ScreenUpdating = False

For Each ws In Worksheets
ws.Activate

' do your formatting here

Next ws

Sheets(1).Activate

Application.ScreenUpdating = True


HTH

Ken
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cycling through collection 8
Error Message - Macro to Unlink MS Queries from Workbook 0
macro to control tabs (different worksheets) 8
Loop Thru Worksheets 2
Printing sheets based on a cell value 1
Cycle through multiple sheets 2
Copying cells and formula from closed workbook to all sheets in open workbook 0
Run macro on all files in a specific folder 3

Back
Top