I'm still having a problem. I've copied the actual code from my program and pasted it below. Tabl(Ncols,3) is a control table indicating what columns in 'Input' should be used to update what columns in 'Detail'. Column 1 in Tabl is the 'Detail' column, column 2 is the 'Input' column, and column 3 is the default if the 'Input' column is null. The row being added is Row. There are 2 strFormula statements. The one that is commented out is the one that blows. The other one sails through with no problem. I really do appreciate your help on this. -- Ham Rutledge
Add_Row:
Set wks = wkbForecast.Worksheets("Detail"

RowMsk = Format(Row, "###"

For i = 1 To Ncols
Range = Tabl(i, 1) & RowMsk
'strFormula = "=IF(Input!" & Tabl(i, 2) & "$" & RowMsk & "=" & Chr$(34) & Chr$(34) & ";" & Chr$(34) & Tabl(i, 3) & Chr$(34) & ";Input!" & Tabl(i, 2) & "$" & RowMsk & "

"
strFormula = "=Input!" & Tabl(i, 2) & "$" & RowMsk
MsgBox (strFormula)
wks.Range(Range).Formula = strFormula
Next i
Set wks = wkbForecast.Worksheets("Input"

Return