Results 1 to 15 of 15

Is there any way to determine what is triggering a name to recalculate?

Threaded View

  1. #1
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Is there any way to determine what is triggering a name to recalculate?

    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)
    Last edited by foxguy; 10-27-2011 at 07:08 PM.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1