Posted to microsoft.public.excel.worksheet.functions
|
|
Print data filled rows only
Perfect! Thx
"Gord Dibben" wrote:
I would suggest you use a Dynamic Range for the PrintRange.
See Debra Dalgleish's site for instructions.
http://www.contextures.on.ca/xlNames01.html#Dynamic
BTW.............I assume you mean "borders" and not "gridlines" as gridlines
cannot be turned on/off via CF
Gord Dibben MS Excel MVP
On Sat, 21 Jun 2008 08:03:01 -0700, Cricket
wrote:
I have worksheet conditionally formatted to show gridlines and data as rows
are used. How do I set conditional print area to include only those rows
showing?
|