My code concatinates N discontiguous cells in a row and work for small data sets, but for a larger dataset (not sure where the breaking point is) I get a Run time error '7' out of memory here: ReDim myresult(1 To LR, 1 To LR)
I need to run this on datasets of upword of 200,000 rows
In searching for a solution many forum threads advised adding Application.EnableEvents = False but it did not help
Thanks
Please Login or Register to view this content.
Last edited by capson; 12-10-2014 at 12:18 PM.
The max the second dimension can take is the max number of columns-16834.Please Login or Register to view this content.
If you are over this limit, you will get out of memory.
Even if, with this limit, you will get another error.
Imagine multiplying the no of rows times 16834, excel can not handle it.
Last edited by AB33; 12-10-2014 at 12:12 PM.
Why are you declaring the second dimension as 1 to LR rather than 1 to 1 anyway?
Remember what the dormouse said
Feed your head
Thank AB33, I added
And thenPlease Login or Register to view this content.
And this fixed my proplem, many thanks!!Please Login or Register to view this content.
I updated the code to reflect this fix
Last edited by capson; 12-10-2014 at 12:24 PM.
But you're only using 1 column...
Hello romperstomper, I am kind of at the limits of my understanding, do you mean I should just use
Instead ofPlease Login or Register to view this content.
Please Login or Register to view this content.
Close:
Please Login or Register to view this content.
I will use that Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks