btadams
Well-known Member
- Joined
- Jan 6, 2003
- Messages
- 1,943
I'm using the Application.Inputbox method to have the user select a cell containing a numerical value:
When the user selects a cell in a different worksheet, it is displayed in the inputbox as ='Sheet 1'!$A$1
However rngMyRng.Address only returns $A$1. How can I get it to return the sheet name as well?
Thanks,
Code:
Set rngMyRng = Application.InputBox("Select cell containing Upper Spec/Control Limit", "Add Spec/Control Limits", , , , , , 8)
When the user selects a cell in a different worksheet, it is displayed in the inputbox as ='Sheet 1'!$A$1
However rngMyRng.Address only returns $A$1. How can I get it to return the sheet name as well?
Thanks,