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.

--
Regards,
Tom Ogilvy

"Dirk Kampfmeier" wrote in message
om...
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.