Find Selected Area's Workbook Name

Hello Everydody,

This is my first post, so I have to tell you I'm very happy I found you.

I have 5 (same time) opened workbooks.

I ask user (via VBA's inputbox) to select an area in worksheet "ws1" of workbook "wbx" (where 2<=x<=5) while the Active.Workbook is "wb1".

the code I use is

dim myRange as Range
Set myRange = Application.InputBox(Prompt:="Please select ...", _
Title:="Area Selection", Type:=8)

this works fine, then I can use

myRange.Worksheet.Name

to get the name of the worksheet where the users selected an area, but

I don't know how to get the name of the Workbook in which the users made it's selection?

Thanks in advance

Re: Find Selected Area's Workbook Name

Thanks guys but I have allready tried

ActiveWorkbook.Name

and it brings me wb1, while I expect a name like wb2, wb3, wb4, or wb5.

I need to use a command or a method in conjunction with variable

myRange

Re: Find Selected Area's Workbook Name

YES Andy
this works perfectly

' workbook
Msgbox myRange.parent.parent.name

In fact, "parent" will offer great functionality to my future codes.

:congrats: :congrats: :congrats:

Thank you all.

Do you think I should publish this small utility I make when I finish it?

Would it be ok to publish it in this thread, or should I start a new one?