That is exactly what I was thinking of

But sometimes it works which proves that data is copied to the
clipboard.

Therefore the only possibility left out is sometimes the data is copied
to the clipboard and sometimes not becuase of which ActiveSheet.Paste
does not work.

I am not sure how to tackle this issue. How do you check the status of
the clipboard? What would be the syntax?