Count to last row and delete

Hi,

On entering a WB i am counting the number of rows in ColA

 lngRow = Cells(Rows.Count, "A").End(xlUp).Row

I now want to clear contents from "A2:M2" down to the last row.

What line of code would i use for this?

Thanks
Seamus
Seamus2626Asked:
Who is Participating?
 
gavsmithConnect With a Mentor Commented:
Range("A2:M" & lngRow).ClearContents
0
 
Seamus2626Author Commented:
Excellent,

Thanks
Gav
0
All Courses

From novice to tech pro — start learning today.