Printing Only Filtered Data

[travis5000]

Anyone have a macro that will print only the data that is currently filtered? I would like this to use my current page set up print options.
- 1 Page Wide
- 30 Pages tall
- Landscape
- Print Area is current the whole section A1:W770. Not sure if this will change based on the macro

Thanks for the help!

 

[Andrew Poulsom]

In what way doesn't File|Print (or the print icon) work?

 

[travis5000]

Ok that was easy! I guess I didnt think it wouldnt do that automatically..