Thread: All Worksheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tjh tjh is offline
external usenet poster
 
Posts: 96
Default All Worksheets

Hello,

I am trying to use code that will perform an action on every worksheet in an
excel file.

I have tried using:

Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets

'''''''''''''some action which will move around on the
worksheet'''''''''''''''''

Next wks

I get an error when using this.

Is there another method to go to each worksheet that is in the file and
perform the same action.

Thank You,