I find this an easier alternative:

Apply Data|filter|autofilter to your column (or whole range).

Then use the filter arrow to show/hide the rows you want.

If you've never used autofilter before, Debra Dalgleish has some info at:
http://www.contextures.com/xlautofilter01.html



david wrote:

I need to hide rows depending on whats in the cells (a1,a2,a3,...)

can somewane give me a example of a macro for this.

thank you

--

Dave Peterson