Can a VBA run too fast?

[matrixpom]

Hi again,

I'm currently running a code that appears to run perfectly but...rather than copying the last row that the code populates, it copies the previous row (the last but 1)? I thought maybe the code was running too fast so i incorporated a 1 second delay, then a 3 & now a 10 second delay without success...can anyone see where i'm going wrong? Thank you all once again - Marco

Code as follows:

Please Login or Register  to view this content.

[mike7952]

Add Lastrow +1 to range you are coping. Because at the start of your code you get lastrow then you add data to the Lastrow + 1. So you need to add +1 to the range you are coping.

And remove the wait don't need it.

[bheanloh]

your code populate LastRow + 1
So, instead of this -> Sheets("2012").Range("A" & LastRow & ":AO" & LastRow).Copy
you should have -> Sheets("2012").Range("A" & LastRow + 1 & ":AO" & LastRow + 1).Copy
Is this what you want?

[matrixpom]

Hi Mike / Boon,

Awesome advice as always guys, code is now working perfectly! Thank heaven for "excelforum" love this place! - Marco