Hiding a range prints blank space

A

Ajit

I have a range with multiple rows which is more than a page. Through code I
sometimes hide the range. Now after hiding the range if i go to excel sheet
it shows the range hidden, but when i print it blank space prints...

Anybody having an idea what could be the reason ?
 
T

Tom Ogilvy

Hidden rows don't print nor can they be viewed. Are you sure you have
hidden the rows and you don't have code to unhide them.
 
T

Tom Ogilvy

your not using the hidden property in format=>Cells=>Protection tab are you.
the row height for these rows should be zero.

Rows(1).Hidden = True

Not

Rows(1).cells.FormulaHidden = True

Just a guess as this wouldn't make the cells appear blank.

Maybe you need to move the sheet to another workbook and recreate it.
 
Top