ExcelBanter - printing with out data

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - printing with out data (https://www.excelbanter.com/excel-programming/402652-re-printing-out-data.html)

printing with out data

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

"pgarcia" wrote:

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

printing with out data

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

"JLGWhiz" wrote:

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

"pgarcia" wrote:

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