Re: 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 <Cricket@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I have work*** conditionally formatted to show gridlines and data as rows
are used. How do I set conditional print area to include only those rows
showing?


.