out of memory error
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 |
out of memory error
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 . |
out of memory error
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 . |
All times are GMT +1. The time now is 08:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com