Dear Experts,
I have received a new computer some weeks ago and I am
trying to run my old macros on it.
I have a problem with one of these, though. It looks
pretty straightforward, the macro loops through one wbook,
compares one cell at a time to a range in a second wbook,
and when/if it finds a match it copies some cells from the
first wbook in the second.
The code that is giving me problems is:

Workbooks(before).Activate
Workbooks(before).Worksheets("before STAR").Range(Cells(i,
Blastqtitycolumn + 2), Cells(i, Blastpricecolumn)).Copy

I don't know why, it takes a lot of time and apparently
memory to perform this (even if the range consists of only
approx. 5 cells!), so much that the macro stops because of
lack of memory.

Do you know why this is happening and if I could somehow
modify my code to make the macro easier to run?

Many thanks!
Kind regards,
Valeria