Thread: For Each Next
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Darrin Henshaw Darrin Henshaw is offline
external usenet poster
 
Posts: 38
Default For Each Next

At least I don't get the error now. But what does happen is that the
actions I need to perform are only happening in the activeworksheet, not
any of the others. Here's an update to the code:

Dim wksht As Worksheet
Application.ScreenUpdating = False

For Each wksht In ActiveWorkbook.Worksheets

Point to note, this same thing happens if I use Sheets, instead of the
ActiveWorkbook. Thanks.

*** Sent via Developersdex http://www.developersdex.com ***