Hidden Rows

[Curt]

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

[Don Guillett]

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

--
Don Guillett
SalesAid Software
donaldb@281.com
"Curt" <Curt@discussions.microsoft.com> wrote in message
news:4D9FFB53-881F-4BB3-837F-E2A036257FC0@microsoft.com...
> 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

[Curt]

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
> donaldb@281.com
> "Curt" <Curt@discussions.microsoft.com> wrote in message
> news:4D9FFB53-881F-4BB3-837F-E2A036257FC0@microsoft.com...
> > 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
>
>
>

[Chip Pearson]

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" <Curt@discussions.microsoft.com> wrote in message
news:613E7E97-0EE7-4147-A2EC-CA5A139EB40D@microsoft.com...
> 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
>> donaldb@281.com
>> "Curt" <Curt@discussions.microsoft.com> wrote in message
>> news:4D9FFB53-881F-4BB3-837F-E2A036257FC0@microsoft.com...
>> > 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
>>
>>
>>

[Curt]

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" <Curt@discussions.microsoft.com> wrote in message
> news:613E7E97-0EE7-4147-A2EC-CA5A139EB40D@microsoft.com...
> > 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
> >> donaldb@281.com
> >> "Curt" <Curt@discussions.microsoft.com> wrote in message
> >> news:4D9FFB53-881F-4BB3-837F-E2A036257FC0@microsoft.com...
> >> > 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
> >>
> >>
> >>
>
>
>