Method to recalculate functions in cell?

[Klopper]

If I have this code in an Excel VBA module:

Function MyFunc
MyFunc = (Range("A1&quot.value) + 10
End function

And I enter in to any cell, lets say B2, in the spreadsheet:

=MyFunc()

I get returned in cell B2 the value in cell A1 plus 10. Which is good!
But, how can I programmatically recalculate the value in B2 when the value in A1 has changed? ie what is the code to refresh / recalculate the cells that use custom built functions?

TIA
Klopper

 

[SkipVought]

Hi,
You need to have a dynamic target range rather than a static range...

Function MyFunc(rng)
    MyFunc = (rng) + 10
End Function

Skip,
metzgsk@voughtaircraft.com

 

[SkipVought]

...actually, to be rigerously correct, the syntax should be:

Function MyFunc(rng As Excel.Range)
    MyFunc = (rng) + 10
End Function

Skip,
metzgsk@voughtaircraft.com