Reverse columns using VBA

Hello to everybody,

As told you at my first post, I'm still learning VBA :-)
Now I'm working on a sheet in which I import some data. Actually I will monthly import some figures, so in the end of the year I will have 12 columns.
In each month the txt file will contain the actual month and the month back until January.

The problem is that my txt file contains the month reversed. It starts all the time with the actual month and ends with January.

To use this sheet in my file I will need to reverse the order, so the first column will be January. Now I found this code:

Please Login or Register  to view this content.

It does the job but only in case if I have a full year. If I import data for 5 month January it will be 6th column, and the first 6 are filled in with 0 values.

I would need your support to find a solution to this code so in any case January will be in the first row.

Thanks a lot!

Just change first two lines to this :

Please Login or Register  to view this content.