Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. *** Sent via Developersdex http://www.developersdex.com *** |