BeforeRangeRetrieve

Occurs before a range is retrieved.

Property	Description
RangeName	Defined name or reference of the retrieved range. When the "used range" is the retrieved range, the property value is null.
SheetName	Name of the sheet that contains the range.