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.
I'm still very much learning all this stuff.
Range("B" & Rows.Count).End(xlUp).Select
This question generated 22 answers. To proceed to the answers, click here.
This thread is current as of April 02, 2015.