josh_oneill
New Member
- Joined
- Feb 13, 2019
- Messages
- 14
Dear All,
I currently have a spreadsheet that will be copied and pasted into a power point presentation each time it is used.
Is there a way to capture a screen print of a given cell range (A1:AE132) or what is currently on screen (Excluding the top ribbon, Formula bar and headings) using a VBA button? i.e. just capture the actual sheet. Then make that available to paste into Power Point? The given area is very large but I have numerous buttons to hide and unhide rows and columns depending on what view the user needs.
Thanks,
Josh
I currently have a spreadsheet that will be copied and pasted into a power point presentation each time it is used.
Is there a way to capture a screen print of a given cell range (A1:AE132) or what is currently on screen (Excluding the top ribbon, Formula bar and headings) using a VBA button? i.e. just capture the actual sheet. Then make that available to paste into Power Point? The given area is very large but I have numerous buttons to hide and unhide rows and columns depending on what view the user needs.
Thanks,
Josh