Print only cells with data in a specified range

I have an excel invoice where in Sheet "INVOICE" Range B11:B31 (on my invoice) product codes are listed .

When I make an invoice, all the cells in range "B11:B31" will not be filled with data.

So when I'm printing the invoice I'd like those cells that are blank (within that selection), NOT to print (the entire row of the blank cell in the range) and so the invoice would shrink up... does this make sense?


Also would want to print only page 1 of sheet "INVOICE"

I have this code to print my file:

Please Login or Register  to view this content.

Should i add both macro to a command button and run it?

Hey so i added a command button and attached macro for hiding and printing.

However I dont want it that way.

When I run your macro then it hides the blank cells in my excel file and then keeps it that way itself.

Is it possible that when printing it automatically does not print blank cells ?

Hey,

I made a command button and added 3 macros to it.

macro 1: to hide rows

Please Login or Register  to view this content.

Macro 2: to print

Please Login or Register  to view this content.

Macro 3: to unhide

Please Login or Register  to view this content.

The problem is that the process takes too long.

It takes way too long to hide, then print, then unhide.

Any suggestions?

Hey thanks,

I will implement this code.

But it hangs up the system for about 5-10 seconds.

Any way to avoid it?