Is there a VBA-based approach to check if a column of data is sorted?

[Juggler_IN]

What I am looking for a vba way to check if data in a column range is in sorted order (default=ascending; optionally=descending). Any suggestions?

 

[RoryA]

You'd have to loop through it checking if each cell was <= the one below it.

 

[Juggler_IN]

@RoryA; other than that no other efficient way?

 

[RoryA]

You could use a formula that essentially does the same thing.