Printing Range

  • Thread starter Thread starter Edgar
  • Start date Start date
E

Edgar

Hi

I use the following code to print out a worksheet.

The problem is that the page has many formulas on it, I
only want to print the cells with values in them and not
the empty formula cells.

How can I do this in code?

TIA
 
Hi Edgar

I don't see your code?

You can print a range like this

Selection.PrintOut
'print only the selection

Range("c1:d5").PrintOut
'print range
 
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

VBA set thick borders around non empty cells in range 0
Excel Need Countifs Formula Help 0
Variable Range Copy... 13
Excel VBA 1
Excel VBA - Problem with Closing Print Preview 0
Macro to print specified range of several work sheets 2
Change event to add button 2
Method to automate page numbers on single worksheet 1

Back
Top