How I print only the cells with data without selecting everytime?
 

I want to print only cells with data without selecting the range everytime.
How do I do that?

How I print only the cells with data without selecting everytime?
 

File Print Area Clear Print Area

Excel will automatically determine the used area and set the print area
accordingly.

--
Carlos

"tkagate" wrote in message
...
I want to print only cells with data without selecting the range
everytime.
How do I do that?

How I print only the cells with data without selecting everytime?
 

"CarlosAntenna" wrote in message
...
File Print Area Clear Print Area

Excel will automatically determine the used area and set the print area
accordingly.

Unless the empty cell have borders around them. It can be done with a
BeforePrint event resetting the Print Area depending on how the data is laid
out.

--
Regards


Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"CarlosAntenna" wrote in message
...
File Print Area Clear Print Area

Excel will automatically determine the used area and set the print area
accordingly.

--
Carlos

"tkagate" wrote in message
...
I want to print only cells with data without selecting the range
everytime.
How do I do that?