Getting macros to Select next column automaticaly

[phillb]

Hi I want to run "Text to Coulmns" on around 700 columns. How do I get VBA to do this. I can record the macro for one column but cannot get it to do multiple columns as below.

Please Login or Register  to view this content.

[johnjohns]

On 31st post please ensure that you are using code tags.

[MarvinP]

Hi philib,
What John means is that you need to EDIT your post and then click on "Go Advanced". Select the code and click on the "#" icon above the message area. This will put code tags around the code so we can read it better.

Now, after you do the above....

Did you know that you can use numbers instead of letters for Columns()?

Please Login or Register  to view this content.

is the exact same as

Please Login or Register  to view this content.

Does that help? If you need to work through a bunch of columns how about a For Next Loop

Please Login or Register  to view this content.

[phillb]

Hi Marvin,

I have tried to alter the macro as suggested but don't think I am doing it right. I need to do columns 3 to 410.

Please Login or Register  to view this content.

[mohd9876]

you forgot the for line:

Please Login or Register  to view this content.

[phillb]

Hi I have entered this, it does seem to highlight and scroll through all of the columns but it does not seem to be working. Could the ("c1") in line 4 be affecting it??

[mohd9876]

yes it could you should replace it by

Please Login or Register  to view this content.

[phillb]

Sorry to be a pain. I have enteredthis and it comes up with "compile error: Argument not optional"

[mohd9876]

sorry my mistake
not

Please Login or Register  to view this content.

just

Please Login or Register  to view this content.