Do a filter (DataFilterAutofilter) and select a value of 0. Delete the
visible rows.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ianalexh" wrote in message
...
this is probably very simple but i am new to writing code (excel 2000).

i want to scan cells M9:M999, and for every cell where the value is 0 i
want
that row deleted. so for instance M9's value is 453 and row 9 will stay,
but
M10's value is 0 so row 10 is deleted. so on and so forth.

thanks so much!
ianalexh