How do I clear cells from row 2 onwards via macro but the last row varies

[ghrek]

Hi

Im trying to clear data from a workbook in columns B.C.D.E from row 2 onwards. I know that you can do ctrl/shift & del to select all cells down the columns but im trying to do it via macro and the issue is that the amount of rows that have data in varies from time to time depending on how much data in there. I can only get a macro to do to the last row when its recording

Is there anyway round this?

Thanks

 

[Fluff]

How about

Sub ghrek()
   Range("B2:E" & Rows.Count).ClearContents
End Sub

 

[ghrek]

How about

Sub ghrek()
   Range("B2:E" & Rows.Count).ClearContents
End Sub

Fluff you are a legend. Many Thanks

 

[Fluff]

You're welcome & thanks for the feedback