Capture range object address

  • Thread starter Thread starter doco
  • Start date Start date
D

doco

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning a range from application.inputbox 5
Similar Book to Book Code, one works other does not 11
Problem getting results of RefEdit into a range 4
Very Easy...Right? 14
Copy FROM - TO Object/Block variable not set 6
Copy to Visible Cells only;Modify Code 11
Code with hidden flaw ERROR 400 13
Select range through Inputbox 2

Back
Top