Sort Dialog Arguments

  • Thread starter Thread starter Dirk Kampfmeier
  • Start date Start date
D

Dirk Kampfmeier

Hi experts!

Is there a possibility to read the Sort-Arguments after the data has
been sorted by the user? In my case I want to mark the sorted Columns.
For more Information see Excel-Help below.

Thanks a lot

----------
Excel-Help for Sort Method:
----------
Remarks
The settings for Header, Order1, Order2, Order3, OrderCustom, and
Orientation are saved, for the particular worksheet, each time you use
this method. If you don't specify values for these arguments the next
time you call the method, the saved values are used. Set these
arguments explicitly each time you use Sort method, if you choose not
to use the saved values.
 
There is no way to read these with builtin capabilities of Excel or VBA that
I am aware of.
 
Back
Top