I'm trying to get rid of all the volatile Dynamic Range Names in my workbook. IOW: I'm trying to get rid of "Offset(....)" in my Range Names.
I have a Range Name that uses a UDF() 2 times. I have verified that the UDF() has "Application.Volatile False" as it's first line. The UDF() is being executed hundreds of times when I move my cursor.
Is there some way to determine what cells are triggering the Range Name to recalculate?
Or maybe an explanation of why the UDF() is being triggered when all I do is move my cursor?
Here are the UDF() and Range Names. $A$13 and $A$15 have #s in them (no formulas).
Function WC(ByVal r As Range) As Range Application.Volatile False If Not r Is Nothing Then Set WC = r.Cells(1, 1).EntireColumn End If End Function Range Name: BaseCol ReversTo: =WC($CC$22) Range Name: Base RefersTo: =INDEX(BaseCol,$A$13):INDEX(BaseCol,$A$15)
Bookmarks