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

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

Guest

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.
 
CarlosAntenna said:
File > Print Area > Clear Print Area

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

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
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

Excel VBA - Problem with Closing Print Preview 0
Stop Macro running when I save the workbook 1
Excel Need Countifs Formula Help 0
Excel print area which only prints pages of worksheet which are active 0
Print same form with different, listed data 4
How can we convert OST to PDF file format? 1
Assigning a Worksheet Name to a Cell 4
Looking up data in different sheet 4

Back
Top