hiding rows

[dido22]

Hello,

I know how to hide a row or rows, but is there a way of automatically hiding
rows that contains no data ?

Thanks

K

 

[Gord Dibben]

You can hide blank rows using Autofilter but that would not be "automatic".

Automatic usually means VBA.

Do you want to go that route?

 

[Gord Dibben]

Too fast on the trigger<g>

Give us an idea of what you want hidden and what would be thr triggering event.

i.e. data entry in a cell or cells?

Calculated value(s) reach a certain point?

A selection is made?


Gord Dibben MS Excel MVP

 

[Dezy]

Hello,

I know how to hide a row or rows, but is there a way of automatically hiding
rows that contains no data ?

Thanks

K

Here is the link to get an idea..

http://www.excelforum.com/showthread...16#post1713316

http://www.excelforum.com/excel-general/578873-hiding-rows-with-a-cell-containing-0-a.html