Print data filled rows only
 

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?

Print data filled rows only
 

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?

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?