"Excel cannot complete this task with available resources"

Hello all,

I know this error ocurred to some of you and I've been reading about it. Still I'm not able to solve my problem. I'm using a macro that worked perfectly until now but, from today, I get this error. When I do the debug it looks like the error is here:


error excel.JPG

Then, if i go back to the first line of the image, and do it manually, it works perfectly.


Any idea why this is happening?

Thank you!

in your code replace from the line Columns("L:S").Select to the end with the below line

Please Login or Register  to view this content.

Hi JotaPinto and welcome to the forum.

This sounds like you need more memory in your machine.

Always avoind using the select, copy and paste in you code to save the memory.

in your code replace from the line Columns("L:S").Select to the end with the below line

Please Login or Register  to view this content.