vba get workbook object from range code example

Example: vba get workbook name from range

myRange.Worksheet.Parent.name