Hi Everyone,

I am getting an Application Defined / Object Defined Error (1004) on a long formula... Can you help me find the problem? Thanks for your help!



ActiveCell.FormulaR1C1 = _
"=IF(HLOOKUP(TEXT(TODAY()+R14C,""M/D/YYYY"")&"" DT"",R2C2:R10C57,RC4,FALSE)>0,(HLOOKUP(TEXT(TODAY()+R14C,""M/D/YYYY"")&"" DT"",R2C2:R10C57,RC4,FALSE)&(IF(HLOOKUP(TEXT(TODAY()+R14C,""M/D/YYYY"")&"" DT"",R2C2:R10C57,RC4,FALSE)>1,"" Drums @ "","" Drum @""))&(HLOOKUP(TEXT(TODAY()+R14C,""M/D/YYYY"")&"" MT"",R2C2:R10C57,RC4,FALSE))),(ROUNDUP((HLOOKUP(TEXT(TODAY()+R14C,""M/" & _
")&"" MT"",R2C2:R10C57,RC4,FALSE))*0.9,0)&"" - ""&ROUNDDOWN((HLOOKUP(TEXT(TODAY()+R14C,""M/D/YYYY"")&"" MT"",R2C2:R10C57,RC4,FALSE))*1.1,0)))"