Selecting an entire column minus two cells.

[111StepsAhead]

I am trying to swap columns of data at the click of a command button.

I originally found this code to swap the columns.

Please Login or Register  to view this content.

However, when I try and swap a column that contains a command button I get an error. In my code is a sub Build_Menu. This is how I create my command buttons quickly. The function Create_Command_Button decides what the dimension of the button will be. Finally, the cmdButton4_Click was originally part of a command button in my real spreadsheet. Now it is just the code to swap two columns. When you select two columns at the top and run the sub it will swap the two areas. If you do the same thing in a column with a command button an error pops up.

What I would like is for someone to show/ help me make the code so a user can select the columns and then have the code automatically not swap cells in row 1 or 2.

Thank you in advance.

[Dave H9]

I can't get your code to run but you could try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[111StepsAhead]

Yes, thank you Dave H9. That is what I was looking for a very long time. I am worried that the code didn't work for you though. Was it the swap code or the command button create code? In the file I gave you the command buttons are already created so if you try and create them again nothing will appear to change. There will just be two layers of command buttons.

[Dave H9]

I'm glad it worked for you : ).

Not running on mine is possibly due to my excel version but no worries as long as your sorted.

Cheers

[111StepsAhead]

Ahh, but what if I needed backwards compatibility some day? Not that I won't find out eventually when I get to testing but the less bugs I have now the easier my future will be. If you don't feel like bug hunting that is fine though. Have a nice Monday.

[Dave H9]

OK, got it to work by transferring cmdButton4_click into a standard module. Your code does the column swap but bugs out at -

Please Login or Register  to view this content.

"Run-time 32809 - application defined or object defined error"

I'm not sure what this bit of the code is trying to acheive!