TBC Macros and Extensions

 View Only
Back to discussions
Expand all | Collapse all

could a Sheet-Sort-Rank smaller than 0 and greater than 100 lead to any issues?

  • 1.  could a Sheet-Sort-Rank smaller than 0 and greater than 100 lead to any issues?

    Posted 03-28-2022 22:46
    Edited by Ronny Schneider 03-28-2022 22:48
    In the properties pane for a sheet you can set the Sort-Rank only to values from 0 to 100.
    Via macro I can set it to <0 and >100. That works, the properties pane shows those values and the sheets are sorted in the correct order.

    What's is the reason for the properties pane being limited to 0-100?
    Could my rank setting outside this range lead to any unwanted complications?


    Edit: funny Forum error, you can't have <> in the thread subject, I had tried several times with the following subject line "could a Sheet-Sort-Rank <0 and >100 lead to any issues?" and always got an undefined error


    ------------------------------
    Ronny Schneider
    ------------------------------