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!