Loop thru worksheets(i)
Works fine for me - are you sure you have 32 sheets in your workbook?
"Jim at Eagle" wrote:
Dim i As Byte
i = 22
Do While i < 32
Worksheets(i).Range("J14:K28").ClearContents
i = i + 1
Loop
I have tried many ways but allways get one of several errors when the
worksheet line is run. Any help here will be greatly appreciated.
--
Jim at Eagle
|