convert formula to macro.

Test 11.xlsm

The above sample I need to convert the formulas in d32,k32,r32,y32,d65,k65 into macros. also i need to add a button on each line that when hit will stop that macro from running. If i can not convert formula to macro is there a way to create a stop button on each line that will stop the formula from running.

Add this macro.

You might want to delete the formulas in the cells listed above,

double clicking on a cell

will insert its formula
and the replace it with its value

Please Login or Register  to view this content.

is there a way for me to put a command buttond for each line to stop running this macro when it is hit?

Dont' think its working. I put it in this workbook and i am not getting the answer in the cell?