I have a worksheet with a column D "Quantity" and a column E "Level", both of which are named ranges. The formula I am using in column F is quite simple =IF(quantity<level,"X","")
This works on the worksheet, but I don't want it to recalculate every time a value is changed.
What I have been trying to do (unsucessfully) for the last hour or two is to incorporate this formula into a macro that can be called from a button on a userform. I would like to remove the formulas from column F and just have the procedure run when the button on the userform is clicked. Ideally, I would like to be able to select the last cell with information in it from column D and use that as the end of the loop. This seems to be simple but I just can't figure out how to do this.
Any help would be appreciated.
This message was edited by RWinfield on 2002-04-21 13:37
This message was edited by RWinfield on 2002-04-21 13:37
This message was edited by RWinfield on 2002-04-21 13:38
This works on the worksheet, but I don't want it to recalculate every time a value is changed.
What I have been trying to do (unsucessfully) for the last hour or two is to incorporate this formula into a macro that can be called from a button on a userform. I would like to remove the formulas from column F and just have the procedure run when the button on the userform is clicked. Ideally, I would like to be able to select the last cell with information in it from column D and use that as the end of the loop. This seems to be simple but I just can't figure out how to do this.
Any help would be appreciated.
This message was edited by RWinfield on 2002-04-21 13:37
This message was edited by RWinfield on 2002-04-21 13:37
This message was edited by RWinfield on 2002-04-21 13:38