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!!

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


Martincito23 wrote:

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!!

--

Dave Peterson

This works perfect!
Thank you very much for your help, Dave!

"Dave Peterson" wrote:

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


Martincito23 wrote:

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!!

--

Dave Peterson