Hi Bob,

use Autofilter to select the rows that you want to delete,

press F5 special - select visivable cells only

hth
regards from Brazil
Marcelo


"Bob Salzer" escreveu:

I have a workbook that contains energy information about every floor of
a building. In column 'Z' there could be a message called 'no savings'.
What i want to do is delete these
rows. I have started by selecting a range within column 'z' from 10 to
175.
now comes the problem. As i read through each cell how do i check the
field for 'no savings'
and then how do i delete the row? i have tried almost everything except
for the one that works. If anyone out there can help me i would sure
appreciate it. thanks, bob