re-run macro automatically ?

  • Thread starter Thread starter biff
  • Start date Start date
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
 
Sounds like a udf. Did you put
application.volatile
as the first line of the udf?
 
great, that's it !
thanks

Biff
-----Original Message-----
Sounds like a udf. Did you put
application.volatile
as the first line of the udf?

--
Don Guillett
SalesAid Software
(e-mail address removed)



.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running a macro when selecting an item in a drop-down list 4
Running a macro from windows application 1
q re macro and function 1
Using ontime to plot data automatically 2
Macro runs on cell value 1
Macro for all Excel Workbooks to print to PDF 2
Pasting Formula Based on 2 Existing Formulas 2
Writing a macro to compare columns and return a value 1

Back
Top