(Solved) – VBA code copy paste working for weeks and then st

  • by
(solved)-–-vba-code-copy-paste-working-for-weeks-and-then-st

I had the following code is a worksheet:

Sheets("Open SO").Select
Range("D:D,F:F,H:H,J:J,L:L,N:N,P:P,R:R,V:V").Copy
Sheets("SO Sum").Select
Range("F1").Paste

This worked fine for several weeks. Then one day there is an error.

What would make this change?

I updated the code (in 15 places) to:

Sheets("Open SO").Range("D:D,F:F,H:H,J:J,L:L,N:N,P:P,R:R,V:V").Copy Sheets("SO Sum").Range("F1")

And now it works fine. Just wondering what was wrong with the other code and why it worked for weeks and they stopped working all of the sudden?

Leave a Reply

Your email address will not be published. Required fields are marked *