[islandgirl321]

I need an excel macro to refer to a different column each time I run the same macro. Does anyone know what the syntax is for this?

[islandgirl321]

If anyone can help that would be amazing as I have to try and get this done before work tomorrow! Ahh!

[turbodante]

Originally Posted by islandgirl321

I need an excel macro to refer to a different column each time I run the same macro. Does anyone know what the syntax is for this?

Not 100% sure if I understand what you mean. Do you want the macro to select the column from the cell that has been pre-selected by the user?

If so, then this line may help...

Columns(Selection.Column).Select

If not, please restate what you want the macro to do.

[turbodante]

Welcome to the forum btw.

[Rollin_Again]

Please post your existing code so we can understand what you are trying to achieve.

Regards,
Rollin

[Zack Barresse]

Hi there, and welcome to the board!

You definitely need to post more information, as has been requested. What would help us is if you gave us a detailed description of the data you have and how it's structured. I.e. headers in range xx:yy, data is from range aa:zz, etc. Also, what it is you are trying to achieve with your macro, the end result. But start point, and end point, as detailed as possible.

[islandgirl321]

Thanks guys, sorry. Ill get more info from my computer at home tonight and repost! Thanks

[islandgirl321]

An example of what I'm trying to do is as follows:

My data is in column C and column A is empty. When I run the macro the first time I want to insert a column to the left of column C so then my data moves to column D. I then want to copy the data column D and past into column C.

The second time I run the Macro I want to do the same as above but start from column D. Column A is still empty, and therefore I want to insert a column to the left of column D so then my data moves to column E. I then want to copy the data column E and past into column D. And so on...............

I therefore I need some sort of looping syntax, refer to an empty column syntax as a starting point if I have to and refer to the next column up from where I started every time the macro is run.

I'm new to all of this.

Please help!!!!

[bomb #21]

Are you saying you want the code to operate on the first free column?

[islandgirl321]

yes! Can i also tell it what the first free column is?

sorry if im confusing!

[islandgirl321]

It will also move down one column every time, but the new column will always be empty

[bomb #21]

"I want to insert a column to the left of column C so then my data moves to column D. I then want to copy the data column D and past into column C."

If I read that right then copying the last column one column to the right of the last column gives the same result but goes about it more methodically.

Sub test()
LastColumn = ActiveSheet.UsedRange.Columns(ActiveSheet.UsedRange.Columns.Count).Column
Columns(LastColumn).Copy Cells(1, LastColumn + 1)
End Sub

(adapted from ozgrid)

[islandgirl321]

Thanks, I'll have a go at that now and let you know how it goes! Thanks for your time!