Code for copy/pasting sometimes does not work properly

Hi,
I have a code for copying and pasting that sometimes works, and sometimes does not. When it does not work, gives error 1004: copy area and paste area are not the same size.
I am struggling whith this problem for a while and can't get past it.

P.S. Some stuff in my code you might find unnecessary, but I learn as I go. Also, this type of work in the code will be repeated at least 10 times, but instead finding "si", I will do various other elements like Fe, Hg, La...

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Glad it worked out. Without seeing your workbook, it's hard to tell why you had that problem.