Retrieve sort columns. Excel 2003.

[Vagelisr]

Hi to all.

First of all I’m sorry for my English.

Let’s say i have a sheet with 4 columns and make a sort from vba in column b if i go in excel in data and after in sort they know i have make a sort in column b

I would like to know if there is any way to retrieve the sort column or columns of a sheet via VBA.

Thanks and regards.

[davesexcel]

Hi Vagelisr,

Welcome to the forum

Could you supply more detail of what you want to happen?
What is suppose to happen with this retrieved column?

[Vagelisr]

Depend of the short i want to show and hire different columns.
Is there any way VBA tells me that in my worksheet is sorted by columns A and B or only column A or only column B

Thanks for your time.......

[davesexcel]

Not sure what you mean, you are the one who determines what gets sorted.

[Vagelisr]

I have make a macro that sort my workbook by somy columns.
I want with some how when user add a line the sort to extended in the new line.
Is there any way to do this???

Thanks again for your time.....

[watersev]

it's possible if you put sorting macro on Worksheet_change event but it will be not efficient (after each data row inserted the user will wait for sorting to complete), easier will be to sort data after all necessary rows have been added