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

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
.