macro to clear data among different sheets

[RAM72]

Hi all
Am looking a macro to clear contents in same workbook but different ranges in the sheets tabs.
However row 1 for each sheets has headers that should not be cleared
E.g row 2 column A to AA sheet 1 to last data row
E.g row 2 column A to U sheets and so on
On some sheets i need to clear the formating also but have some other sheets not.
However there are some uncontigious columns in which there is no data.

Thanks if any can help

 

[Marc L]

Hi !​

However row 1 for each sheets has headers that should not be cleared

E.g row 2 column A to AA sheet 1 to last data row​

Sheet1.Cells(1).CurrentRegion.Offset(1).ClearContents …

Use Clear property to clear all or ClearFormats to just delete formating …
​

 

[Marc L]

However row 1 for each sheets has headers that should not be cleared

E.g row 2 column A to AA sheet 1 to last data row​

However there are some uncontigious columns in which there is no data.

Sheet1.UsedRange.Columns("A:AA").Offset(1).ClearContents …
​

 

[RAM72]

Sheet1.UsedRange.Columns("A:AA").Offset(1).ClearContents …
​

Thank you Marc exactly what i was looking