You can, using VBA, hide and unhide rows based upon the value in A1

How does A1 get its value? Must be a calculated return.

Your parameters look faulty to me.

0 can be < 1 and/or < 1 can be 0


Gord Dibben MS Excel MVP

On Tue, 27 Oct 2009 09:33:04 -0700, Jeremy
wrote:

Is there a way to automate hiding of rows where if A10 Rows 1 and 2 will be
hidden and if A1<1 Rows 1 and 2 will show?

Thank you