From Activecell, Paste cell value on current row into column A, Column B, D, and G

I'd like to know how to paste data from the clipboard into a specific column of the activerow without using the .offset functionality. The problem is the workbook that i have created uses a lot of offsets but now I want to go in and remove some columns and that will completely throw off all of my offsets (as far as where they are copied and pasted to). I saw in someones code that they had used something like Range("A" & current row).Paste (this right here doesn't work)

What I'm trying to do is go from where the activecell is (generally in column A or B of any row) and I want to be able to use the above type of code to paste into columns by using the Column letter.

Does that make sense?

Thanks in advance!

Maybe like this

Please Login or Register  to view this content.

Thanks! Works like a charm!