ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Select current region and print (https://www.excelbanter.com/excel-programming/327714-select-current-region-print.html)

Tempy

Select current region and print
 
Good day,

I am filtering a form and only want to print the results of the filter.
I have tried using current region to no avial, could somebody please
assist with some code.

Thanks,

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

Tom Ogilvy

Select current region and print
 
Range("A1").CurrentRegion.Printout

Only visible rows will be printed

0r

Activesheet.Autofilter.Range.Printout


--
Regards,
Tom Ogilvy

"Tempy" wrote in message
...
Good day,

I am filtering a form and only want to print the results of the filter.
I have tried using current region to no avial, could somebody please
assist with some code.

Thanks,

Tempy

*** Sent via Developersdex http://www.developersdex.com ***




Tempy

Select current region and print
 
Thanks Thom

Tempy

*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 12:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com