Macro to hide blank cells in a range

G

Guest

I have an input sheet that has multiple cells for data input. Not all cells
are used on a monthly basis. I go through and hide the rows with blank input
cells. Each month, the cells are not blank, so I can not write a macro to
hide row 1-6.

Is there a macro that will evaluate the cells in the range and hide all rows
that do not have data in the specified cells?

Example:

If my range is A1:F111 and column D has the input cells, is there a macro
that would hide rows 15-20, 28-29, and 43 because the corresponding cells in
column D have no data?

Thanks
Dave
 
N

Nick Hodge

Dave

Record a macro running the autofilter on column D with the criteria as
blanks. It maybe you only wanted that feature highlighting and you won't
need a macro

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
 

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

Macro to hide rows with zero in specifc column range 2
Hide rows of cells that are blank 9
How do you hide multiple row macro 1
VBA set thick borders around non empty cells in range 0
Hide blank cells in either of 2 columns 3
deleting rows with blank cells after a specified column? 3
I would like a range of cells to become blank if they are idle for 1
After Macro runs, no cell activated - what am I missing? 2

Top