Text to Columns VBA code not working

[bjcowen9000]

Hey, for some reason I keep getting this error: "Microsoft Excel can convert only one column at a time." Does anyone see my problem? I just want to take the info in column AM and text to columns starting in AN:

Please Login or Register  to view this content.

[bjcowen9000]

Now it said no data was selected to parse. It could be that I do not have any info in the first cell and so it stops?

[bjcowen9000]

I now have the following code and it says no data was selected to parse? I do not understand? Some of the cells in column AN do have data (not all of them):

Please Login or Register  to view this content.

[Norie]

You need to check if there's data.

Try this.

Please Login or Register  to view this content.

[bjcowen9000]

I actually got it, but thanks for the help!