auto hiding blank rows

J

Jase

I have a range of data with about 200 rows. Usually a chunk of about 20 rows
towards the bottom is blank. I would like to hide those rows automatically
and if they do suddenly have values to automatically unhide them. Is their a
way to do this?

thanks,

Jase
 

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

auto hiding blank rows and columns 5
Printing: fit to 1 page 2
auto hide blank rows 1
How to hide rows having a specific value in cell of column A ? 0
trying to get data from rows to columns 4
How To Have A Cell Be Blank If... 2
Auto Hide Blank Rows 1
After Macro runs, no cell activated - what am I missing? 2

Top