How do I get the workbook name from a range object? I can easily get the worksheet name, but I can't find how to get the Workbook name. I can say:
to get the worksheet name, but I don't know what the equivalent call is to get the Workbook name.![]()
shtName = myRange.Worksheet.Name
Thanks
Bookmarks