Thanks for the help. I've resolved my initial issues. Based on the Google research, I got the impression that Evaluate only works with cell references and will not work with VBA fields. So, I updated a temp cell with my initial value from the "value" field, then used the EVALUATE reading my original formula Text cell. So, final answer is:

1. Formula Cell = sum(Temp!$AA$1 * -1)

This has the reference to my temporary holding cell AA1 on TEMP worksheet.

2. VBA Code =

ThisWorkbook.Worksheets("Temp").Activate

ThisWorkbook.Worksheets("Temp").Range("AA1").Activate

ActiveCell.value = value

value = Evaluate(FldCalc(cnt))

FldCalc is a Collection where I'm storing the text formulas.

What I'm hoping now, is that I can put almost any Excel or VBA formula into my Formula column and have it execute. But, I expect to have to tweek it as I go.

Again, thanks for the input.

Gary