drums4monty
02-13-2011, 07:59 AM
Hi All
I need to delete the contents of 63 worksheets in a workbook in a specific range, I wrote the following code but all it does is delete the first sheet 63 time and does not move onto the other sheets, can someone help/explain my problem.
For i = 2 To 63
Set sh = Worksheets(i)
Range("C5:G45").Select
Selection.ClearContents
Range("A2").Select
Next i
Kind regards
Alan
I need to delete the contents of 63 worksheets in a workbook in a specific range, I wrote the following code but all it does is delete the first sheet 63 time and does not move onto the other sheets, can someone help/explain my problem.
For i = 2 To 63
Set sh = Worksheets(i)
Range("C5:G45").Select
Selection.ClearContents
Range("A2").Select
Next i
Kind regards
Alan