User Input - sheet and ranges
 

I am having a mental block right now! ahh!

How can I get the user to point to a range on a sheet and get the sheet name
and range name?

Thank you.

Richard

User Input - sheet and ranges
 

Hi Richard,

Try:

Set mycRng = Application.InputBox("Select range", Type:=8)

MsgBox myRngl.Address(External:=True)



---
Regards,
Norman



"Richard Mertl" wrote in message
...
I am having a mental block right now! ahh!

How can I get the user to point to a range on a sheet and get the sheet
name
and range name?

Thank you.

Richard

User Input - sheet and ranges
 

Hi Richard,

There is a typo.

MsgBox myRngl.Address(External:=True)

should read:

MsgBox myRng.Address(External:=True)

---
Regards,
Norman