Run-Time Error 1004 Paste Method of Worksheet class failed

[jtsains]

I am running code on thousands of lines of data with a loop. The code runs smoothly for a long time then will debug on the public function below. It goes through this paste function many times and just quits working randomly.

I am coping data from a Reflections session then finding the cell in the excel sheet where i want the data posted. This is the only location where it stops. When i select continue on the macro, it will run again with no issue for another thousands times but then it stops again.

I have tried numerous paste options and this is the only one that works properly, but it just doesn't work sometimes.

Any suggestions:

Public Function PSV()
Pause
ActiveSheet.Paste
End Function

(Pause is another public function that tells the Reflection session to wait.)

 

[JLGWhiz]

I am running code on thousands of lines of data with a loop. The code runs smoothly for a long time then will debug on the public function below. It goes through this paste function many times and just quits working randomly.

I am coping data from a Reflections session then finding the cell in the excel sheet where i want the data posted. This is the only location where it stops. When i select continue on the macro, it will run again with no issue for another thousands times but then it stops again.

I have tried numerous paste options and this is the only one that works properly, but it just doesn't work sometimes.

Any suggestions:

Public Function PSV()
Pause
ActiveSheet.Paste
End Function

(Pause is another public function that tells the Reflection session to wait.)

Since it works a thousand times before a hiccup, the code is obviously not the problem. Generally speaking, this error occurs when the paste area is not equal to the copy area. The only real way to see why it errors is to look at where the focus was at the time the error occured. Since you are using modular code (more than one procdure in the overall program) it could be a tedious task isolate that one in a thousand occurence.

 

[jtsains]

It happens in the same column, A1 of the spreadsheet each time; however, it is this same column that works thousands of times before. It can't be the cell itself because when i click continue, then it finishes pasting the data as expected without issue.