Issue with multiple paste

[cairo9]

Hi,

I am new and have self learnt VBA from the internet, hence getting stuck at a basic issue. I tried my best to google the solution- but failed.

My code:
Selection.Copy


Sheets("A").Select
Cells(b, c).Select
ActiveSheet.Paste



Sheets("B").Select
Cells(b, c).Select
ActiveSheet.Paste

So it is copying perfectly, pasting it fine in Sheet A, after that for some reason the clipboard is getting cleared and I am getting Run-time Error 1004 once it reaches Sheet B..
Basically I am trying to do Ctrl C followed by Ctrl V, for multiple pasting, however it is doing Ctrl C followed by Enter.
Please advise.

I am using Office Professional 2016.

 

[Peter_SSs]

Thanks Peter- cannot thank you enough for all your help. I made mySheets2 and repeated the loop and it works perfectly fine.

Great, good that you could adapt it yourself.
Glad to have contributed.