Help With Formula Needed.

[Nigel Martin]

Is it possible to run a macro from within formula in a cell and still refer to another cell? eg [formula is cell B1]=if(a1>0,run macro****;G1) so it would check to see if A1 is greater than 0 then go off and run the macro then let the cell with the formula in = whatever is in cell G1.

 

[Abdc]

You cannot run a macro from a worksheet formula.
A UDF can be included in a formula.