How do I ask the user to click on a sheet and have that sheet name be stored in a variable that I can later use in a statement like...
Let MyVariable = the worksheet name that the user selected.
Worksheets!MyVariable.Select
'Then do some processing with with this worksheet
Any point in the right direction would be appreciated.
Thanks,
David
Let MyVariable = the worksheet name that the user selected.
Worksheets!MyVariable.Select
'Then do some processing with with this worksheet
Any point in the right direction would be appreciated.
Thanks,
David