Delete 2 last rows

[Rafael02]

I need to delete my 2 last populated rows, i have this code:

Range("B" & Rows.Count).End(xlUp).Offset(1).Select

that will select the row right below the last populated cell. I need the macro to select the two rows above the one that the code selects, and delete it!

THANKS!

 

[mgm05267]

Hi...

Range("B" & Rows.Count).End(xlUp).Offset(-1).Select

Try this

Regards,

MGM

 

[Rafael02]

Oh! thanks you so much, it worked! Also if i put (0) it will select the other one! Thanks a lot