Hidden Rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Curt - 23 May 2005 14:42 GMT

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.

Signature

Thanks

Reply to this Message

Don Guillett - 23 May 2005 15:14 GMT

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

Signature

Don Guillett
SalesAid Software
donaldb@281.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.

Reply to this Message

Curt - 23 May 2005 18:10 GMT

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???

Signature

Thanks

> You can use a worksheet_change event macro. Right click sheet tab>view code>
>
> > 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.

Reply to this Message

Chip Pearson - 23 May 2005 20:21 GMT

Try

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

Signature

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

> This is the code I am using but it keeps giving me an error:
>
[quoted text clipped - 10 lines]
>> > visible else they
>> > will be hidden.

Reply to this Message

Curt - 24 May 2005 02:12 GMT

Thank you Chip, it works great

Signature

Thanks

> Try
>
[quoted text clipped - 18 lines]
> >> > visible else they
> >> > will be hidden.

Reply to this Message