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
|