Code
 

I am using the code shown below. The lines with *'s in front of them wont
work. I'm pretty sure it has something to do with the calcualtion in them.
Can anyone tell me how to change this so it will work. I'm trying to add
formulas to a worksheet.

Thank you very much for any help you can send my way.

Case "UHCNEW"
Call FormatUHCNEWSheet
Call InsertFormula(GetRowCount("C"), 15,
"=IF(ISERROR(FIND(""$"",S#,1))=TRUE,P#,"""")")
Call InsertFormula(GetRowCount("C"), 13,
"=IF(ISERROR(FIND(""$"",S#,1))=FALSE,N#,"""")" )
**Call InsertFormula(GetRowCount("C"), 28,
"=IF(ISERROR(FIND(""%"",S#,1))=FALSE,1,IF(ISERROR( FIND(""$"",S#,1))=FALSE,2,3)")
**Call InsertFormula(GetRowCount("C"), 20,
"=IF(AB#=""1"",S#,IF(AB#=""3"",N#/W#/100,""""))=SUM(T#*V#))")
**Call InsertFormula(GetRowCount("C"), 21,
"=IF(AB#=""2"",S#,""""))=SUM(U#*V#)")
Call InsertFormula(GetRowCount("C"), 4,
"=if(C#=""override"",""N"",""Y"")")
Call InsertFormula(GetRowCount("C"), 24, "=Tables!A#")