Printing Range

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
 
R

Ron de Bruin

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
 
Top