out of memory error

  • Thread starter Thread starter rosanne
  • Start date Start date
R

rosanne

I am building a formula for a cell on a worksheet by
building it up in a string and then setting the
ActiveCell.formula to that string. The string isn't
really all the large. It looks like this for 5 rows:

=('Segment Rates by CY'!$C$7*$Q$13)+('Segment Rates by CY'!
$C$7*$Q$14)+('Segment Rates by CY'!$C$12*$Q$15)+('Segment
Rates by CY'!$C$2*$Q$16)+('Segment Rates by CY'!$C$2*$Q$17)

When it is complete for 16 rows I get the following error:

Error 7 - Out of Memory.

Any ideas would be greatly appreciated.

Thanks
 
Hi,

If the formula is too long (i can't remember the exact
number of characters), it will return the Out of Memory
error.

Regards,
 
Hi,

If a formula is too long( I can't remember the exact
number of characters), it will retrun the error.

Regards,
 
Back
Top