+ Reply to Thread
Results 1 to 4 of 4

re-execute vba function

  1. #1
    Nader
    Guest

    re-execute vba function

    Hello,



    I have create a function in excel using vba and I would like to refresh that
    function without going in each cell and press enter. Is there a way to do
    that programmatically?



    Thanks in advance.



    Nader



  2. #2
    Forum Contributor colofnature's Avatar
    Join Date
    05-11-2006
    Location
    -
    MS-Off Ver
    -
    Posts
    301
    You could either make your function volatile by adding

    Application.Volatile

    to it's code, thus making it recalculate when any other function does, or use the Calculate method of the Workbook, Worksheet or Range in which your function appears, e.g.

    Application.Calculate


    Col

  3. #3
    Nader
    Guest

    Re: re-execute vba function

    Thanks a lot Col. It's working prefectly.

    Nader

    "colofnature" <colofnature.28z80p_1149590411.6815@excelforum-nospam.com> a
    écrit dans le message de news:
    colofnature.28z80p_1149590411.6815@e...rum-nospam.com...
    >
    > You could either make your function volatile by adding
    >
    > Application.Volatile
    >
    > to it's code, thus making it recalculate when any other function does,
    > or use the Calculate method of the Workbook, Worksheet or Range in
    > which your function appears, e.g.
    >
    > Application.Calculate
    >
    >
    > Col
    >
    >
    > --
    > colofnature
    > ------------------------------------------------------------------------
    > colofnature's Profile:
    > http://www.excelforum.com/member.php...o&userid=34356
    > View this thread: http://www.excelforum.com/showthread...hreadid=548894
    >




  4. #4
    Nader
    Guest

    Re: re-execute vba function

    thanks a lot !
    "colofnature" <colofnature.28z80p_1149590411.6815@excelforum-nospam.com> a
    écrit dans le message de news:
    colofnature.28z80p_1149590411.6815@e...rum-nospam.com...
    >
    > You could either make your function volatile by adding
    >
    > Application.Volatile
    >
    > to it's code, thus making it recalculate when any other function does,
    > or use the Calculate method of the Workbook, Worksheet or Range in
    > which your function appears, e.g.
    >
    > Application.Calculate
    >
    >
    > Col
    >
    >
    > --
    > colofnature
    > ------------------------------------------------------------------------
    > colofnature's Profile:
    > http://www.excelforum.com/member.php...o&userid=34356
    > View this thread: http://www.excelforum.com/showthread...hreadid=548894
    >




+ Reply to Thread

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