Refresh Excel cells on demand
Thank you.
I try it but the function did not get called.
--
Roland
"AA2e72E" wrote:
Press Ctrl + A followed by F9 to refresh all cells with UDF
or, programatically, for an individual cell, say E5,
Range("E5").Activate
Calculate
"Roland" wrote:
I would like to add a button or a menu pick to Excel asking it to refresh all
cells which referances a user defined function in an Add-in.
For example:
Cells
a1
=ExternalData("source1")
a2
=ExternalData("source2")
...
After button click ExternalData should refresh its data.
Any help would be great!
Thanks
Roland
|