G
Guest
Guest
How can I edit this code to ignore sheets 1 and 2 and always start at worksheet 3 ?
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If IsEmpty(ws.Range("B2")) Then _
ws.Range("B4:B36,G6:G29").ClearContents
Next ws
Eugene Robinson
Rhos on Sea
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If IsEmpty(ws.Range("B2")) Then _
ws.Range("B4:B36,G6:G29").ClearContents
Next ws
Eugene Robinson
Rhos on Sea