hiding rows with a macro

I haven't done any kind of programming in about 5 years. What I want to do
is, have a IF function in cell "A1" that checks if "C1" has anything <> than
0. If it is <> 0 leave row1 visable, if it =0 then hide row1. I need to do
this for about 20 rows, if later data is entered in "C1" thru "C20"it would
automatically Hide or unhide the rows.

is this possible?

I don't think you can do it in a cell, but you could do it with VBA.
I see a possible flaw in your arrangement. You say you want to automatically
hide or unhide rows depending on the value of a cell in that row. If the row
is hidden, you would not be able to edit the data, so you would never be in
a position where the row needs to be unhidden.

--
Ian
--
"Lee" <[email protected]> wrote in message
news:[email protected]...
>I haven't done any kind of programming in about 5 years. What I want to do
> is, have a IF function in cell "A1" that checks if "C1" has anything <>
> than
> 0. If it is <> 0 leave row1 visable, if it =0 then hide row1. I need to do
> this for about 20 rows, if later data is entered in "C1" thru "C20"it
> would
> automatically Hide or unhide the rows.
>
> is this possible?

There are innumerable answers in the archives:

http://groups.google.com/advanced_gr...ugroup=*excel*

But I've got a question for you: If row 1 is hidden, how will the user
enter anything in Row 1? Yes, it can be done, but it's hardly user
friendly.

In article <[email protected]>,
Lee <[email protected]> wrote:

> I haven't done any kind of programming in about 5 years. What I want to do
> is, have a IF function in cell "A1" that checks if "C1" has anything <> than
> 0. If it is <> 0 leave row1 visable, if it =0 then hide row1. I need to do
> this for about 20 rows, if later data is entered in "C1" thru "C20"it would
> automatically Hide or unhide the rows.

I forgot to mention that the information in Cell "C1" is coming from another
sheet


"JE McGimpsey" wrote:

> There are innumerable answers in the archives:
>
> http://groups.google.com/advanced_gr...ugroup=*excel*
>
> But I've got a question for you: If row 1 is hidden, how will the user
> enter anything in Row 1? Yes, it can be done, but it's hardly user
> friendly.
>
> In article <[email protected]>,
> Lee <[email protected]> wrote:
>
> > I haven't done any kind of programming in about 5 years. What I want to do
> > is, have a IF function in cell "A1" that checks if "C1" has anything <> than
> > 0. If it is <> 0 leave row1 visable, if it =0 then hide row1. I need to do
> > this for about 20 rows, if later data is entered in "C1" thru "C20"it would
> > automatically Hide or unhide the rows.
>