Hiding a range prints blank space

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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.
 
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.
 
You must log in or register to reply here.

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

need a macro to set the print range only for visible rows 1
Eliminate blanks while copy row and transpose 11
hide rows of blank cells 2
Excel VBA - Problem with Closing Print Preview 0
Macro to Hide blank rows 4
hiding blank rows 3
Not statements and blank page printing 2
Hide blank rows - what is wrong with this code ??? 3

Back
Top