Let me try to be more clear.

In my data series I have all my cells linked up to another page for
formating purposes, usually about rows 170 to 195 are blank data. Instead of
showing all these blank rows I would like them to be hidden. Then if data
does appear in these rows they will unhide. I just want a macro that I can
run that will go through and look for blank rows and hide them if they r
blank.

thanks,

Jase

"Mike H" wrote:

Hi,

How will they get these values if they are hidden?

Mike

"Jase" wrote:

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