Move cols to a dynamc place using R1C1

[DetroitDavid]

I import a csv file of data and need to move some columns of information around. Columns A&B always need to go into another place, but the sheet is dynamic in that the number of columns of data changes (if I have more phone numbers, the sheet gets wider to accommodate. So, I can't Move say A:A to Z:Z because I don't know where it should go.

However, I do know how many columns I have via a number, let's say 29. So, in this case if I wanted to move A&B to the forth column from the end (moving the far right 3 over two to create space), I'd like to move A:B to R1C26:R1C27

Can someone give me some direction?

TIA-DD

 

[steve the fish]

Try this:

x = 29
Columns("A:B").Cut Destination:=Columns(x - 3)

 

[DetroitDavid]

Thank you!!!