re-run macro automatically ?

B

biff

Hi

I have a macro, e.g. myMacro(a, b)

when i use this Macro within an ExcelCell with references
to other cells, i.e. i enter
=myMacro(A1, B7)
the result is calculated correctly. so far so good.

But when i change the cell value in A1 or in B7 the result
does not change. Even with <F9> i cannot bring the macro
to recalculate with the new cellvalues.
How can i do this ?

Biff
 
D

Don Guillett

Sounds like a udf. Did you put
application.volatile
as the first line of the udf?
 
Top