printing with out data

[pgarcia]

I've setup a spreed sheet that has formulas from A19:Q1000. You can not see
the formula in less there is data. How can I print out the visable data and
not have Excel want to print out 20 pages with now visable data? e.g. page 1
has data from A1:Q30.

Also, can you suppres the "PAGE 1" in the middle of the sheet?

Thanks

 

[JLGWhiz]

You can manually set the print area of a file. Check the help file for Print
Area

 

[pgarcia]

Yes, I know. But I was looking for a VB code to just select the print area
for me as the data changes daily.