LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default returning blank when reference cell is blank

Another question if you don't mind - I'm going to share this log that some
may print out. I noticed when doing a print preview, that all the "blank"
rows show up to print. Without having to change the print area, how do I
specify to only print where there are values in the rows? (we have people
who get trigger happy and waste paper and also are not versed in the Print
Area feature)

Thanks.

"Dave" wrote:

Thanks for the feedback.
Dave.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
returning blank cell when conditions not met kfarley Excel Worksheet Functions 4 March 17th 08 10:24 PM
Returning a blank cell rather then #N/A (Lookup) Monk Excel Discussion (Misc queries) 2 January 24th 06 03:16 PM
how to get excel to display blank if reference cell blank silent1(not) Excel Worksheet Functions 1 December 2nd 05 02:49 PM
returning blank cell sbigelow Excel Worksheet Functions 2 October 9th 05 03:53 PM
returning blank cell in criteria o Joop Excel Discussion (Misc queries) 3 June 3rd 05 02:11 PM


All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"