Write your own macros so that Excel2007 cells or columns move left and right

① Click the menu bar-view-macros-to view the macros.

② Pop-up Macro interface, enter the name of the macro, here to facilitate memory, we named to move one column to the left, and then click the Create button.

③ in the new appearance of the interface, the input code, that is, the program language, I have written, you can copy directly.

application.screenupdating = False

x = Selection.column

If x >= 1 Then

Columns (x). Cut-and

Columns (x-1). Insert

application.screenupdating = True

End If

④ exit the edit state, select the cell or the entire column, and execute the macro. Below, I'll move the right one column of code also to everyone.

application.screenupdating = False

x = Selection.column

If x < 256 Then

Columns (x). Cut-and

Columns (x + 2). Insert

End If

application.screenupdating = True

End Sub