| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine if a worksheet is sorted
Is there any way (property or otherwise) in VBA to determine if a worksheet
is already sorted, and if so, what the sort key(s) is/are? -- Message posted via http://www.officekb.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determine if a worksheet is sorted
Not that I know of. You could write a macro to loop through all the
columns, and in each column, loop through all the cells and determine by brute force if that column is sorted either ascending or descending. That would be an indicator that the data is sorted by that one column, but even that is not foolproof. HTH Otto "Fox via OfficeKB.com" <u18899@uwe wrote in message news:5fc322b87ff94@uwe... Is there any way (property or otherwise) in VBA to determine if a worksheet is already sorted, and if so, what the sort key(s) is/are? -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to check sorted data in an excel worksheet | Excel Discussion (Misc queries) | |||
| copying cell contents from one worksheet to another (re-sorted lis | Excel Discussion (Misc queries) | |||
| Excel formulas pulling from another worksheet changes when sorted | Excel Worksheet Functions | |||
| Links not updated when primary worksheet is sorted | Excel Worksheet Functions | |||
| how do i recover a consolidated worksheet that i sorted/subtotale | Excel Worksheet Functions | |||
Linear Mode
