Capture range object address
 

I am using Set oMyRange = Application.InputBox(Prompt, Title, Type:=8) to
capure user range input. I see in the refedit box on the inputbox that
"Sheet1!$E$24" shows up but the worksheet name is dropped when capturing the
address, IE, $E$24 is what is returned. I want the worksheet to be returned
as well.

How may this be done?

TIA

doco

Capture range object address
 

Never mind - what a bone head!!

This works...

Set oMyRange = Application.InputBox(Prompt, Title, Type:=8)

MsgBox = oMyRange.Address(True, True, ,True) ' Returns
[Book]Sheet!Address



"doco" wrote in message
...
I am using Set oMyRange = Application.InputBox(Prompt, Title, Type:=8) to
capure user range input. I see in the refedit box on the inputbox that
"Sheet1!$E$24" shows up but the worksheet name is dropped when capturing
the address, IE, $E$24 is what is returned. I want the worksheet to be
returned as well.

How may this be done?

TIA

doco