ExcelBanter - Set print area using macros

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Set print area using macros (https://www.excelbanter.com/excel-discussion-misc-queries/121688-set-print-area-using-macros.html)

SheriQuezon

Set print area using macros

Can anyone help...this is what i need...a button with a macro attached so
that it auto-sets the print area to include only the cells with values? IE -
if there were only 10 rows of data with input, then the print area would be
set accordingly; if there were 200 rows of data , the print range would be
set accordingly; etc
--
SheriQ

All times are GMT +1. The time now is 03:14 AM.