Basically, if a cell in my worksheet equals "1", run Macro X. Is there a formula I can put into the worksheet (i.e. =if(B47=1,application.run "macro",0) which of course doesn't work!, or do I have to use some code in the macro that watches the value of the cell?
Thanks!
Thanks!