+ Reply to Thread
Results 1 to 8 of 8

Why Does Custom Function in Name Get Called Twice?

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-30-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2013
    Posts
    173

    Re: Why Does Custom Function in Name Get Called Twice?

    This is explained here
    Excel first tries to calculate named ranges. The first attempt to calculate TestRef fails because the R parameter is Dirty. TestRef is scheduled for re=calculation after the input parameter has been calculated. The sheet is then calculated and then TestRef is calculated again. So TestInfo is hit twice.

    This one is only hit once...
    Function TestNothing() As String
        MsgBox "TestNothing "
    End Function
    Last edited by coolblue; 07-21-2014 at 04:31 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Why is a custom function running when it is not called.
    By Rob K in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-02-2014, 07:37 AM
  2. [SOLVED] Userform code fails when the userform is called from a custom ribbon button
    By klonbeck in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2013, 03:00 PM
  3. Replies: 0
    Last Post: 02-21-2013, 08:28 AM
  4. Need to know what cell called the custom VBA function?
    By partyOfOne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2005, 01:05 PM
  5. [SOLVED] Custom Function being called when it shouldn't.
    By Ron in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-18-2005, 04:06 PM

Tags for this Thread

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