Since your macro doesn't have any range arguments, Excel has no
reason to believe it needs to be recalculated. Instead of using
getting the range values inside the procedure, make the relevant
ranges parameters to the function. E.g.,
=MyMarco(A1,A2)
Since Excel sees that your macro is dependent upon A1 and A2, it
will properly calculate the result when either A1 or A2 changes.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Luis Piņeiro" <Luis wrote in
message
...
I have developed a marco function in VBA for Excell Office 2003.
The macro contains references to cell values as part of its
calculations.
I set another cell C so its value is the one returned by the
macro:
"=MyMacro()"
If I change any of the cells values to which the macro makes a
reference,
the cell C does not update automatically. I have to edit the
cell and press
OK (that is, doing no real editorial changes) to force the cell
value to be
re-calculated.
Pressing F9 did not work.
Do you know how to make such recalculation automatic?
Thanks in advance!