Copy & Paste to the next empy cell. (Vba Code not Working)

Hello,

I created a macro button to copy a cell and paste value in another sheet but it just replaces the value in the same cell on the other sheet. I need it to count the columns and continue to paste the value in the next cell to the right. The code below is what i currently using to make it happen, this worked on prior spreadsheets I have done but not sure what I'm doing wrong. Please Help..




Col = Sheet3.Cells(11, 11).CurrentRegion.Columns.Count + 1

Sheet3.Cells(11, 11) = Sheet2.Range("E10")

Cross posted
https://www.mrexcel.com/board/thread...rking.1131272/

https://www.ozgrid.com/forum/index.p...e-not-working/