clearing the whole sheet except first row

[lezawang]

Hi
The code below is to clear the whole sheet except the first row.

Rows("2:"& Rows.Count).ClearContents

I am unable to understand it. I would appreciate it if you can break it down so I can understand the logic behind it.
Thank you so much

 

[CROY1985]

rows.count is evaluating what the final used row of your sheet is. Lets say it is 10.

The above therefore says Row("2:10").clear contents

This is the equivelent of selecting rows 2 through 10, right-clicking, then hitting "Clear Contents"

 

[RoryA]

Rows.Count returns the number of rows on the sheet, so it's:

Rows("2:1048576").ClearContents

for a new format workbook.