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?

File > Print Area > Clear Print Area

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

--
Carlos

"tkagate" <[email protected]> wrote in message
news:[email protected]...
> I want to print only cells with data without selecting the range
everytime.
> How do I do that?
>

"CarlosAntenna" <[email protected]> wrote in message
news:[email protected]...
> 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

[email protected]
[email protected] with @tiscali.co.uk


"CarlosAntenna" <[email protected]> wrote in message
news:[email protected]...
> File > Print Area > Clear Print Area
>
> Excel will automatically determine the used area and set the print area
> accordingly.
>
> --
> Carlos
>
> "tkagate" <[email protected]> wrote in message
> news:[email protected]...
>> I want to print only cells with data without selecting the range
> everytime.
>> How do I do that?
>>
>
>