Hi. Just an observation. My computer has 2 gigs of memory, and I get the
same "out of memory" error with this:

Dim m(1 To 7000, 1 To 7000) As Variant

When I switched it to Double, I was able to fill the array with numbers.

Dim m(1 To 7000, 1 To 7000) As Double

Don't know it that could help. Are you working with a Sparse array, where
most of the numbers are zero?
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"MCM" wrote in message
oups.com...
hi guys,

I am trying to solve some big numerical problems with VBA excel code
but when the dimension of matrix reaches to a critical number, for
example 7000x7000, compiler gives
"out of memory" problem. what to do in this situation?

thanks.