-
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")
-
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules