+ Reply to Thread
Results 1 to 3 of 3

Sort by String Length

  1. #1
    Registered User
    Join Date
    11-09-2018
    Location
    Hyderabad
    MS-Off Ver
    2007
    Posts
    7

    Sort by String Length

    Hi,


    SORT BY STRING LENGTH


    Here I want to sort by column no 3 but first 2 rows were not having the same columns and getting error "Invalid column number", can anyone alter the below code according to my need. (selection table range should be from row no. 3)


    Below code has to exclude the first 2 rows and it should be consider from 3rd row because from third row it has a uniformity columns...

    Table selection range should be from row no 3

    Please anyone do the needful....


    Below code source : 2 Smart Ways to Sort a Column of Texts by Length in Your Word - Data Recovery Blog


    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Sort by String Length

    Cross-posted at: https://www.msofficeforums.com/word-...ng-length.html
    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Sort by String Length

    Also cross-posted at: http://www.vbaexpress.com/forum/show...-String-Length

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extract string from variable length string
    By JeffGrant in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2021, 03:47 AM
  2. Replies: 12
    Last Post: 02-07-2020, 03:51 AM
  3. [SOLVED] Length of string, not value related to string appearing in input box prompt.
    By ColdDay in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-23-2014, 05:32 PM
  4. [SOLVED] Shorten string length if exceeds 31 characters (max sheet name length)
    By r2fro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2014, 05:57 AM
  5. Max string length of Shape.Fill.UserPicture(PictureImage as String)?
    By AlvaroSiza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2013, 09:36 AM
  6. Replies: 1
    Last Post: 01-22-2013, 03:45 PM
  7. [SOLVED] Translate form data into a text string and output that string into a preformated length
    By TJ Saulnier in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-19-2012, 03:58 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1