View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SheriQuezon SheriQuezon is offline
external usenet poster
 
Posts: 1
Default 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