Printing a dynamic print area

  • Thread starter Thread starter Alex D Coker
  • Start date Start date
A

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,

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
 
Back
Top