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