Printing Range
 

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

Printing Range
 

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




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Edgar" wrote in message ...
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