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
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
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
Thanks a lot Col. It's working prefectly.
Nader
"colofnature" <[email protected]> a
écrit dans le message de news:
[email protected]...
>
> 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
>
thanks a lot !
"colofnature" <[email protected]> a
écrit dans le message de news:
[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks