Hi,
Is it possible to sort a range automaticly? Meaning, a pre selected range is every time sorted (Descending) when new values are added or changed.
Ranpak
Hi,
Is it possible to sort a range automaticly? Meaning, a pre selected range is every time sorted (Descending) when new values are added or changed.
Ranpak
It's possible using a macro:
- Turn on the macro-recorder ( Tools, Macro, Record new macro)
- Do the sorting you want
- Turn o the macrorecorder
- Copy the macro you created to the VB-object of the workbook you sorted and place it between
On my site you'll find a description how to copy code for a macro.![]()
Please Login or Register to view this content.
Success
It Works fine. Thanks WintE.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks