Delete Lines

I need to run a macro the will delete the entire line if it finds the following name in Colum A, it needs to look at all lines 1 - 65536 (Excel 2003)

Hub
Carrier
Cabin

or it can delete all lines that don't contain Entity in colum A which ever is the best way

Then

I would also like it to identify and relace all 0 refences in Colum E and Colum L with the following 0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001


Thanks!

To delete lines, try

Please Login or Register  to view this content.

That worked perfectly! How can I delete the entire row if 0 appears in Colum E & L? This is the preferred way rather than replace it with the value indicated below