Clear data in columns A:E to end

[sshaffer99]

I saw several threads on clearing data, but can't figure out how to do this. I would like to clear the contents of all cells in Columns A:E starting in row 2 to the end of the data (not to the first space, but to the end of the data). Can anyone help with command to do that?

Thank you.

 

[Rick Rothstein]

This would work...

Range("A2:E" & Rows.Count - 1).ClearContents

 

[sshaffer99]

Thank you for such a quick response. This did work, but the row.count came up with something like 418576. Is there any way we can indicate to clear to the end of the data only?

 

[Rick Rothstein]

Thank you for such a quick response. This did work, but the row.count came up with something like 418576. Is there any way we can indicate to clear to the end of the data only?

Why is that a concern? Is the process I suggested too slow for you?