On error and paste.special

[richarddawson]

I have a sub which starts with an On Error GoTo and then continues to use a PasteSpecial.
(I can paste code if required, but I suspect there may be an easy answer from someone here!)

Now if there is nothing to paste it does not go to the label but just stops at the PasteSpecial.

I suspect this is a system thing. I would welcome any comments.

I am using 64 bit 365.

 

[Joe4]

Without seeing the code, we really cannot comment on it.

 

[richarddawson]

I see what you mean!

Where WSped is a defined worksheet

Function pasteTicker()
    On Error GoTo ErrorA
    sleep 1000 
    pasteTicker = 0
    WSped.Range("a1:z500").ClearContents
    WSped.Activate
    WSped.Range("A1").Select
    ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False
    sleep 200
    Exit Function
ErrorA:
    Debug.Print "nothing to paste  " & tickerName
    errorString = errorString + "pasteFail" & " "
    pasteTicker = 999
    Stop
End Function

 

[RoryA]

How are you calling it? (it won't work as a worksheet function if that's what you're trying to do)

 

[richarddawson]

Well it actually does - about 98% of the time.
The error I have is when the site I am getting data from is slow, and there is nothing to paste. (At least I think that is the problem).
I need to do this hundreds of thousands of time so do not want to give unnecessary time.
What I was aiming to do was, if an error was detected, give another copy to the site, and then increase the delay period.

Cheers Richard

 

[RoryA]

That shouldn't work at all if you call it from a cell. If it does, I'm slightly horrified.

 

[richarddawson]

Sorry, I misunderstood you. I don't call it from a cell, I call it in a [longish] programme.

 

[RoryA]

There's nothing wrong with the code, so I'd have to assume something else is interfering, such as event code.

 

[richarddawson]

I have nothing odd in the programme, I have even restricted excel to only using 1 core (well, I did, haven't checked it recently - I will).
It works nicely most of the time.

Have you any suggestions, please?

 

[richarddawson]

Well somehow it had changed back to 8 cores.
But when I changed that the same fault persisted.