I would like to use an input box to ask the user to select a range that may be another sheet. If it is on another sheet, the returned range references only the cells without the sheet. How can I return the source sheet too?
Set myrange = Application.InputBox(Prompt:="Choose a range", Title:="Choose", Type:=8)
'User selects a range on another sheet....
mystring = myrange.Address
Any guidance would be appreciated. Thanks
Bookmarks