property Worksheet: IXLSWorksheet;

This example demonstrates how to obtain the name of worksheet for the specified range.

SheetName := Range.Worksheet.Name;