View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Suppress Printing with Character in Excel File

I understand that some (all?) versions of Lotus 123 support this kind of thing
(using a pipe | character???).

It's not supported in excel (like Gord wrote), but you may be able to mimic it.

Maybe you could apply a filter to hide the rows with that character in it, then
print.

Or you could even run a macro that examines the cell, maybe hides the row,
prints and then unhides the rows.

Shannoni wrote:

Is there a way to suppress printing a line by using a character in a cell?
For example,

IF($B2="","Suppress Print", $B2)

Is there a "Suppress Print" character?

Thanks!


--

Dave Peterson