AUTO HIDE ROWS

G

Guest

Is there a method/function to auto hide rows dependent on the value of a cell
in that row ...

Ie cell B3 = 0 ...... hide row ??!

Many thanks again

Alan
 
R

Ron de Bruin

Hi Alan

With VBA code it is possible to do a auto hide but maybe you
can use Autofilter>custom to do what you want
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide Rows If Condition True 2
Creating a function to auto hide rows 1
hide row based on cell value 2
Hide columns based on row values 2
Hiding Rows 5
How do I get "auto sum" to subtract hidden cell values from total 3
Excel EXCEL - using a date dependant formula to hide rows 3
Filter zeros from two columns, maybe on different rows 2

Top