Macro Array "Out of memory" any way around this?

**Hyflex** · 12-13-2011, 06:14 AM

Hey, the following macro is coming up with a debug error because I assume the data range im looking at is too big.

In the macro you can see rndTbl is looking at "wsList.Cells(3, "E").End(xlToRight).Offset(1)" in my sheet this goes across over 10,000 columns

Can I get around this anyway?

Please Login or Register  to view this content.

**Hyflex** · 12-17-2011, 06:08 AM

I still haven't been able to fix this, I don't know a solution around this error.

**Steffen Thomsen** · 12-17-2011, 06:18 AM

Wich line is giving you the error.

What does the ubound(arrTbl) return?

**Hyflex** · 12-24-2011, 08:02 AM

The error is thrown up on:

Dim arrTbl As Variant: arrTbl = rngTbl.Value

I'm not sure how you want me to run:

ubound(arrTbl)

**Hyflex** · 12-26-2011, 04:44 AM

I have looked into other ways of doing this but I still can't get it working

**Hyflex** · 12-30-2011, 06:27 AM

Bump as I still can't find a solution.

**Firefly2012** · 12-30-2011, 07:02 AM

Hi

Perhaps you could explain what your ultimate aim is and why you need to create a such a mahoosive array. I think you will need an alternative. You've mentioned the total number of columns (over 10,000!!) but how many records (rows) are we talking?