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