Last cell in table

M

Martincito23

Hi all,

A set of data is given to me, and I'm working on a macro which gives this
table a better format. In the last row of the table you can find the total
for a couple of columns This row is not always the same depending on the
volume of information given in the table. Is there a way to identify these
cells or the row with the macro and delete them?

Thank you in advance!!
 
D

Dave Peterson

Maybe.

Can you pick out a column that contains that Total label?

I'm gonna use column A.

Dim LastRow as long
with worksheets("sheet9999")
lastrow = .cells(.rows.count,"A").end(xlup).row
.rows(lastrow).delete
end with
 
Top