Hi! I have this tricky problem I'm not capable of solving.
I have a cell containing a formula: =0 + (77*33) + (103*22) + (8*11) . What I would like to do is store the value before *33 in one variable, then store the value before *22 in a variable, and lastly the value before *11 in another variable. The values I want to store may change, but the formula will be the same. When all is run, I would like the result of the formula/or the formula to still be intact. Is there anyway to do this?
In this case:
I have a cell containing a formula: =0 + (77*33) + (103*22) + (8*11) . What I would like to do is store the value before *33 in one variable, then store the value before *22 in a variable, and lastly the value before *11 in another variable. The values I want to store may change, but the formula will be the same. When all is run, I would like the result of the formula/or the formula to still be intact. Is there anyway to do this?
In this case:
Code:
Variable33 = 77
Variable22 = 103
Variable11 = 8