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
|