Consulting

Results 1 to 10 of 10

Thread: How to define the Key in the sort method of a range

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Tutor
    Joined
    Jun 2005
    Posts
    214
    Location

    How to define the Key in the sort method of a range

    hello,
    What is the best definition of the key in: ActiveSheet.Sort.SortFields.Add Key:= …..
    if all the assigned keys in the attached workbook give the same result?
    How should i interprete the key in this regard?
    And what is the use of .SortFields.Clear?
    It seems to make no difference at all.
    After all, the sort method is applied on a given (current) state of a range.
    Sorted or unsorted.

    regards,
    Stranno
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •