Excel: Clear Cells in Last Row

I have a table where sometimes I need to delete everything in the last row, the table has columns from B to CP1. I have managed to find the last row with vba but have so far only been able to select the cells one column at a time, is there a way that I can select the entire row of cells with data? I used this code to select one at a time.

Range("B" & Rows.Count).End(xlUp).Select
I'm still very much learning all this stuff.

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of April 02, 2015.

For more resources for Microsoft Excel