Printing a dynamic print area

[Alex D Coker]

I have a worksheet that uses external data, refreshed each time I open. The
print area has to be reset each time so that the empty rows with formulas in
the cells aren't printed. Not knowing the amount of data that will be
inserted, I copied the formulas up to row 200. This gives me plenty of room
for the external data, but I don't want all of the empty rows in my
printout.

Any ideas?

Alex D Coker Home:901.861.2818 Fax:901.861.2459 Mobile:901.870.5615

 

[Dave Peterson]

Apply data|filter|autofilter and show just the non-blank cells. Then print
that.

 

[Alex D Coker]

Dave,

Excellent! Worked exactly as I needed.

This will allow me to automate the printing of the report. I plan to move
this to a server for monthly printing.

Thanks
Alex