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

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?

"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?