Macro to hide and unhide rows

**Slinky** · 04-03-2011, 08:10 AM

Hi Guys
Is there an easy way to hide rows in a worksheet when there is a zero value in a certain column.
Thanks

**Colin Legg** · 04-03-2011, 08:17 AM

Hi,

Sure, autofilter that column for "does not equal" 0?

**Slinky** · 04-03-2011, 08:27 AM

Is there another way if I didn't want to use auto filter?

**davesexcel** · 04-03-2011, 08:59 AM

Hide rows based on criteria

That would be a great search base.

**Slinky** · 04-03-2011, 11:48 AM

Looks like I will be carrying on with the auto filter.

Re: Macro to hide and unhide rows