Post Selected Columns into next available column

[jgcramer]

I am trying to write a macro that copies specific columns and then inserts them into the next available column. This is what I currently have

Please Login or Register  to view this content.

I'm getting selection not valid, I believe it's because its not selecting the entire column which i want it to do. Any suggestions? Thanks for the help.

[patel45]

your code works on my excel 2010, but you can change so:

Please Login or Register  to view this content.

otherwise attach a sample file

[jgcramer]

column example.xlsm I couldn't send the exact file because it includes sensitive information but here is something similar to what I am working on, the macro kinda works in this example but its not in the one I'm working in. The macro copies the columns just fine but then fails when it tries to insert, i believe it has to do with the fact

Please Login or Register  to view this content.

selects a cell and not an entire column. is there a way to select the entire next available column and then insert the copied columns there?

[patel45]

If the macro works in the example but not in the original attach the original with sensitive data changed

[jgcramer]

Not sure why but now it's working, I didn't change a thing, Thanks for the help