Trying to clear data on two sheets only data 1 and data 2 but do not delete row1 which are headers on both sheet .
as below but not working
However the range in data 1 sheets are are from column A to O
and data 2 are from range A to G
But in both sheets there may be headers column which are blank
Can Anyone assist,
Sub clearme Sheets (Array(" data1", "data2")) Rows("2:" & Rows.Count).ClearContents End Sub
Bookmarks