D
Darrin Henshaw
I'm feeling like a dummy at the moment. I'm using the For Each statement
to cycle through all sheets in the activeworkbook, and perform actions.
However, I have not used them befoer, and need help. This is what I
have:
Dim wksht As Worksheet
Application.ScreenUpdating = False
For Each wksht In ActiveWorkbook
'code to perform actions
Next wksht
But I get the error, "Object doesn't support this property or method".
Help! Thanks.
to cycle through all sheets in the activeworkbook, and perform actions.
However, I have not used them befoer, and need help. This is what I
have:
Dim wksht As Worksheet
Application.ScreenUpdating = False
For Each wksht In ActiveWorkbook
'code to perform actions
Next wksht
But I get the error, "Object doesn't support this property or method".
Help! Thanks.