Macro to print screen
 

I have a spreadsheet, that contains many rows of data.(300)
A-M

When using the s/s I will filter to show the required data. I would expect
that once filtered the maximim number of rows would be no greater than 20

I would like to put a macro button on the s/s that would print just the
details filtered
and only show columns A-J

its a bit like set the print area and print, - but not that simple