D DeViL_LaW Nov 11, 2003 #1 can any1 tell me the formula to run a macro from an if statement? eg =if(a1>a2,macro...,macro...)
D Don Guillett Nov 12, 2003 #2 try right click on the sheet tab>view code>insert this>SAVE Private Sub Worksheet_Calculate() If Range("a1") > Range("a2") Then Macro1 Else Macro2 End If End Sub
try right click on the sheet tab>view code>insert this>SAVE Private Sub Worksheet_Calculate() If Range("a1") > Range("a2") Then Macro1 Else Macro2 End If End Sub
