if cell = 0 then hide the row?

Al,

If you don't want to do it with a macro, you can achieve this using a
filter. In a column that you don't use (say column M), enter the
formula = F3 in cell M3 and copy down to cover your rows of data.
Highlight this column and select Data | Filter | Autofilter. Then
select Custom... on the pull-down list and specify "Not Equal to" and
"0" (i.e. zero) in the panels. All your rows with zero in column F will
be hidden.

Pete

Problem with that is it needs to be repeated every time a value is changed
to 0, it is not event driven.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Pete" <pashurst@auditel.net> wrote in message
news:1134388888.499724.56670@g47g2000cwa.googlegroups.com...
> Al,
>
> If you don't want to do it with a macro, you can achieve this using a
> filter. In a column that you don't use (say column M), enter the
> formula = F3 in cell M3 and copy down to cover your rows of data.
> Highlight this column and select Data | Filter | Autofilter. Then
> select Custom... on the pull-down list and specify "Not Equal to" and
> "0" (i.e. zero) in the panels. All your rows with zero in column F will
> be hidden.
>
> Pete
>