Consulting

Results 1 to 4 of 4

Thread: Sort range from one empty row to the next empty row Custom

  1. #1
    VBAX Newbie
    Joined
    Nov 2022
    Posts
    2
    Location

    Sort range from one empty row to the next empty row Custom

    Hello everyone,

    I have an Excel spreadsheet where columns A,B;C,D are filled with data.


    The first line is empty and should remain empty.


    Column B shows the engine model and every time there is an engine change, there is a blank line.


    In the photo is line 6.


    I now want to sort the first area up to the empty row ascending first by column C then by column A.


    Then the area should be taken by the empty row to the next empty line and sorted again by column C and column A ascending.


    And so on.


    Attach a photo section of my file.


    How do I have to write the VBA command, since the lines for sorting can always be of different lengths. Ask for help.

    Vielen Dank im Voraus.fd1d09788-unbenannt.jpg
    Last edited by Aussiebear; 11-24-2022 at 01:01 PM. Reason: Convert to English

  2. #2
    see the sub on module1.
    Attached Files Attached Files

  3. #3
    VBAX Newbie
    Joined
    Nov 2022
    Posts
    2
    Location
    wow a lot of thanks to you that is great. This is exactly that what i searched. Regards

  4. #4
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,701
    Thanks for the feedback.
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Posting Permissions

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