Out of Memory condition

Hello... I have a workbook with 5 tabs, none of which have a significant amount of data (less than 50 rows/10 columns in all but 1, which has about 121,000 rows and 2 columns). There is also 1 form.

The functionality in the workbook has been spot on, but when I add a process to remove items from a blacklist (hard coded for now), I get the Out of Memory error. When I comment it out, everything works fine. Uncomment, and every macro results in the error. I don't see anything egregious here, but maybe one of you has a better idea?

Please Login or Register  to view this content.

Thanks for having a look.

Thanks for the reply...

The sheet with 121,000 rows is the BLACKLIST sheet. Essentially, I need to remove any rows from OUTPUT where a value in that row exists in the BLACKLIST sheet. So if the value in C10 exists on BLACKLIST, anywhere in Column A, I want to delete it from the sheet.

I was thinking about doing a countif formula in the spreadsheet, then removing anything > 0 but that takes a bit longer.

I tried the change above but am still getting the out of memory. It's weird though ... even if I run a DIFFERENT macro, I get the out of memory. But if I comment the code above, everything works fine.

Thank you - I was getting the same thing when I changed it to LONG... I also tried defining the range as variant with no luck.

I just noticed something else ... when I closed Excel and reopened the file, the VBA editor was showing me my current project as well as one I had opened earlier today. In Task Manager, I saw 3 instances of "excel mashup evaluation container". I killed those and it's working fine again.