Macro Help - removing certain cells

[Eddie82]

Good morning,

I want to set up a macro across tabs where I remove certain cells what contain un-needed information.

this information is spread across 2 rows that appear in different locations but always at the bottom of the current work book.

is there a way to have rows containing certain words be deleted?
or.. have the bottom 2 cells with text deleted?

 

[Eddie82]

Hi all,

I have found a solution that seamed to work very well...

if you start recording a Marco,
then hit 'F5'
then hit the 'special...' button
I clicked the 'Last cell' radial button and hit ok.
then under the 'HOME' tab I clicked the 'Delete' icon down arrow and selected 'Delete sheet rows'