Query the Sort Key(s)

  • Thread starter Thread starter RobWN
  • Start date Start date
R

RobWN

xl '03 / XP

Is there any way to determine the "Sort By" keys via VBA?

I want to determine if a sheet has had its order changed since the last time a procedure was run
so I can produce an error.
 
Check the top cell(s) vs. the bottom cell(s) of the area in question...
Are they the same as before? - probably requires a module level variable.
-or-
Is the top cell greater than the bottom cell? - an easy check to do.
-or-
Place a copy of the sort area in a hidden area and vet.
--
Jim Cone
Portland, Oregon USA


"RobWN" <[email protected]>
wrote in message
xl '03 / XP
Is there any way to determine the "Sort By" keys via VBA?

I want to determine if a sheet has had its order changed since the last time a procedure was run
so I can produce an error.
 
Thanks Jim.
I assume then that the answer is no.
(I should have known that, it would have been too simple.)
 
Back
Top