Hidden Rows

Is there a way to hide a row till information is entered?

Example: If cell c1 > 0 then rows 7 through 10 will be visible else they
will be hidden.
--
Thanks

You can use a worksheet_change event macro. Right click sheet tab>view code>

--
Don Guillett
SalesAid Software
[email protected]
"Curt" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to hide a row till information is entered?
>
> Example: If cell c1 > 0 then rows 7 through 10 will be visible else they
> will be hidden.
> --
> Thanks

This is the code I am using but it keeps giving me an error:

If c1 > 0 Then Row([7]).Visible Else Row([7]).Hidden

Where is my syntax wrong at???
--
Thanks


"Don Guillett" wrote:

> You can use a worksheet_change event macro. Right click sheet tab>view code>
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Curt" <[email protected]> wrote in message
> news:[email protected]...
> > Is there a way to hide a row till information is entered?
> >
> > Example: If cell c1 > 0 then rows 7 through 10 will be visible else they
> > will be hidden.
> > --
> > Thanks
>
>
>

Try

If Range("C1").Value > 0 Then
Rows(7).Hidden = False
Else
Rows(7).Hidden = True
End If



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Curt" <[email protected]> wrote in message
news:[email protected]...
> This is the code I am using but it keeps giving me an error:
>
> If c1 > 0 Then Row([7]).Visible Else Row([7]).Hidden
>
> Where is my syntax wrong at???
> --
> Thanks
>
>
> "Don Guillett" wrote:
>
>> You can use a worksheet_change event macro. Right click sheet
>> tab>view code>
>>
>> --
>> Don Guillett
>> SalesAid Software
>> [email protected]
>> "Curt" <[email protected]> wrote in message
>> news:[email protected]...
>> > Is there a way to hide a row till information is entered?
>> >
>> > Example: If cell c1 > 0 then rows 7 through 10 will be
>> > visible else they
>> > will be hidden.
>> > --
>> > Thanks
>>
>>
>>

Thank you Chip, it works great


--
Thanks


"Chip Pearson" wrote:

> Try
>
> If Range("C1").Value > 0 Then
> Rows(7).Hidden = False
> Else
> Rows(7).Hidden = True
> End If
>
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Curt" <[email protected]> wrote in message
> news:[email protected]...
> > This is the code I am using but it keeps giving me an error:
> >
> > If c1 > 0 Then Row([7]).Visible Else Row([7]).Hidden
> >
> > Where is my syntax wrong at???
> > --
> > Thanks
> >
> >
> > "Don Guillett" wrote:
> >
> >> You can use a worksheet_change event macro. Right click sheet
> >> tab>view code>
> >>
> >> --
> >> Don Guillett
> >> SalesAid Software
> >> [email protected]
> >> "Curt" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > Is there a way to hide a row till information is entered?
> >> >
> >> > Example: If cell c1 > 0 then rows 7 through 10 will be
> >> > visible else they
> >> > will be hidden.
> >> > --
> >> > Thanks
> >>
> >>
> >>
>
>
>