Code to delete selected columns and rearrange columns in order

Hello experts
With the help of a code, I am trying to delete unwanted columns and re arrange the sheet in a required order. I have recorded a macro to do the above. I need your expertise to help me with a shorter correct code to do the above. Please note that I want to delete and arrange the columns in the same sheet.
Thank you in advance.
fyi, This post was unsolved in a forum where I haven't received any response.
https://www.msofficeforums.com/excel...e-columns.html

Hi. Try with:

PHP Code: 

Columns("X:Y").Cut
Columns("D:E").Insert Shift:=xlToRight
Range("N:N,P:Z").Delete Shift:=xlToLeft 


RAJESH SHAH:

Honestly, I thought you already knew.
But it doesn't matter because now I explain it to you:

a) Start by comparing your code from post #4 with what I'll show you below:

Please Login or Register  to view this content.

b) The difference is those 3 dots that we see before the two Columns and Range.

c) What do those "dots" mean?...

d) Simply that both the 'Columns' and the 'Range' refer to the "B2B" sheet that you initially put when writing: With Sheets("B2B").

Understood?

e) And doing that you don't need to select the B2B sheet and you can be with any other sheet activated.

f) By the way: by not putting those points in your post #4, the two 'Columns' and the 'Range' referred to the active sheet and that's the big difference.

Until next time.

.
Ja ja ja

I'll see it.