View Single Post
  #1   Report Post  
Jerry B
 
Posts: n/a
Default How to Dynamically Set Print Area

I have filtered the number of rows and copied them to a separate area of the
worksheet. The number of rows after the filter is unknown. How do I change
the Print Area range of rows to be the number of rows after the filter
(otherwise I will print pages and pages of paper)

Thanks,
--
Jerry B