Application.Inputbox return worksheet name

[btadams]

I'm using the Application.Inputbox method to have the user select a cell containing a numerical value:

        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,

 

[Norie]

Try this.

MsgBox rngMyRng.Worksheet.Name

 

[btadams]

That'll do. Thanks!