View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mslylan2u mslylan2u is offline
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.