Posted to microsoft.public.excel.programming

Edgar[_3_] Edgar[_3_] is offline

external usenet poster

Posts: 40

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing to a range and printing value	Alyssa M	Excel Discussion (Misc queries)	4	February 25th 08 07:57 PM
Printing a named range	RheaS	Excel Discussion (Misc queries)	1	June 27th 07 07:28 PM
Printing from Excel. First row of range to be repeated	Tim Beechey-Newman, UK	Excel Discussion (Misc queries)	1	August 15th 05 10:26 AM
Printing A Range	Bob[_44_]	Excel Programming	1	December 30th 03 04:44 AM
Printing based on a value of a range	Dave[_28_]	Excel Programming	0	September 11th 03 04:34 PM

All times are GMT +1. The time now is 09:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us