[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

[Thomas Lo]

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,
-----Original Message-----
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
.

[Thomas Lo]

Hi,

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

Regards,
-----Original Message-----
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
.