vba get workbook name from range code example Example: vba get workbook name from range myRange.Worksheet.Parent.name