Evaluating a string Formula/Reference in VBA

[dredwolf]

Okay, the function works to the point of getting 1 added to the formula of the reference cell, now..how do I get the value in the string that it gives ...My latest attempt:

Please Login or Register  to view this content.

After the Red highlighted part of the code runs, Hold contains this string: "Jan!B13", so my question is, how do I reference this cell to get the value stored ?

Edit-
And yes, I know i can make the 'Hold =' into a single formula, I just use the multiple assignments to make for easier debugging in the earlier stages

[dredwolf]

nevermind, found a workaround

Please Login or Register  to view this content.

works fine
Thanks for looking though !