Hi,

I am running a looping process that pastes a formula
array into a wbk from data in another wbk. The
underlying books are all based on the same template, just
data for different months. After the data is created, I
save the book and save it also as X.xls to shorten the
name (to keep under 255). This formula array worked over
1000 times. All of a sudden I get to a month where I am
getting the Runtime error -1004. The length of the
formula is 196 char

VBA
ActiveCell.Formula = "=((SUM(((" & dataBk2 & "$C11:$C" &
lrow & "=C10)*(" & _
dataBk2 & "$H11:$H" & lrow & "=" & LTGIndex & "))*((" &
dataBk2 & _
"$AN11:$AN" & lrow & ")))/SUM(((" & dataBk2 & "$C11:$C" &
_
lrow & "=C10)*(" & dataBk2 & "$H11:$H" & lrow & "=" & _
LTGIndex & "))*(" & dataBk2 & "$AO11:$AO" & lrow & ")))^
(1/5)-1)*100"

ACTUAL RESULT STRING
=((SUM((([x.xls]S1!$C11:$C1509=C10)*([x.xls]S1!
$H11:$H1509=500))*(([x.xls]S1!$AN11:$AN1509)))/SUM
((([x.xls]S1!$C11:$C1509=C10)*([x.xls]S1!$H11:$H1509=500))
*([x.xls]S1!$AO11:$AO1509)))^(1/5)-1)*100

If I take the above formula and paste it into the formula
bar and hit ctrl-shft-entr it does work and returns the
correct value.

So, if it's not the 255 char limit problem, I can't seem
to figure out why it works for so many months prior, and
this file is identical in layout that it it would
suddenly not work. There are no errors in the underlying
value. I'm going bonkers b/c all the files are the
same. WHAT CAN I MISSING????? HELP!!!!

TIA,
Kohai

ps - sorry for the lengthy question.