Stack overflow problem

hello,

I'm using the following code and I'm getting a stack overflow error in Excel 2007...does anyone know how to solve this problem??

Please Login or Register  to view this content.

Try removing the"()" after x() in the Dim statement and in the last line before End Sub. Also note that x has 2 dimensions (one for row, one for column) so Ubound(x) should be Ubound(x,1) or Ubound(x,2).

I'm still having the same problem...this is the code I used this time

Please Login or Register  to view this content.

When I hit debug it highlights this x = .Value:

Seems the current region is too large to store x in memory. Have you tried testing the exact same code on a smaller mock up of your data; i.e. with a much smaller current region?