This one works, but I don't like it:
This one doesn't:Sheets(1).Activate Worksheets(1).Range(Cells(2, 1), Cells(8888, 19)).Select Selection.ClearContents Range("A1").Select Sheets(2).Activate Worksheets(2).Range(Cells(2, 1), Cells(8888, 19)).Select Selection.ClearContents Range("A1").Select
Just need some streamlining, a good solution.With Worksheets(1) .Range(Cells(2, 1), Cells(8888, 19)).ClearContents End With With Worksheets(2) .Range(Cells(2, 1), Cells(8888, 19)).ClearContents End With
Bookmarks