Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have gotten a Run-time error '7':
Out of memory message and I do not know why. My code is the Following: Public m2() As Double Public m1() As Double Public Sub jk() j = 41000 k = 817 ReDim m1(j, k) ReDim m2(j, k) End Sub |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You are trying to reserve an incredible amount of memory...
41,000 * 817 * 8(bytes per double) * 2(arrays) is over half a Gig of memory... Memory aside you are not going to be happy with the performance of arrays this big... -- HTH... Jim Thomlinson "Soquete" wrote: I have gotten a Run-time error '7': Out of memory message and I do not know why. My code is the Following: Public m2() As Double Public m1() As Double Public Sub jk() j = 41000 k = 817 ReDim m1(j, k) ReDim m2(j, k) End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming |