Autoselect data on entire column?

Hi, first post so be gentle;-)

I'm new to VBA Macro's.
I have a macro with three different calls to re-arrange our worksheet, rename path and Sort a column on poperty 'number'.
"Sort a column" does not work, not sure what the reason is, but i suspect the datarange. Its hardcoded everytime, whereas i want it to select the entire column as it differs daily, set it to number property and sort ascending.

This is the routine (which doesnt work):

Please Login or Register  to view this content.

The row on which it stops, is this:

Please Login or Register  to view this content.

Any expert here who can show me a good tutorial about this, or knows the answer?


Cheers.

Hi, thanks for the reply.

I have attached a a small portion of the sheet as a xlsx file.
In the regular routine i get the "Error 9", something like "...subscript of of range...".

Also, in column A the data should be numeric so i can compare with other datasheets with vlookup and such methods. I see the property is set as Number, but i can still "convert to number", which puzzles me.

Thanks again.

hi dear bro.
try this code.

Please Login or Register  to view this content.

Almost perfect ;-)
The sorting goes flawless, but how do i set the fields to "numeric" instead of standard?

I tried adding

Please Login or Register  to view this content.

after

Please Login or Register  to view this content.

No luck.

Thanks.