gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,332
- Office Version
- 365
- Platform
- Windows
I have a VBA code that is launched from a userform. It basically goes to a sheet named "HOURS" runs a Filter and then prints. My problem is that I have my program setup to where I can launch the userfrorm (UserForm46) from a number of different sheets say Sheet (1), Sheet (2) or Sheet (3)... When the print macro is run from the userfrom it leaves me on the Sheet titled HOURS. I want to be able to go back to the sheet I lanched it from. Note that it could be from a number of different sheets to its not as easy as Sheets("Sheet (1)").Select . Sheet (1) may not be where its was launched from.
Any suggestions?
Thanks
Greg in Orlando
Any suggestions?
Thanks
Greg in Orlando