+ Reply to Thread
Results 1 to 2 of 2

Macro to bring empty cells of SearchResults to the bottom

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    SG
    MS-Off Ver
    Excel 2007
    Posts
    37

    Macro to bring empty cells of SearchResults to the bottom

    I've a search sheet (SearchEngine) to query for certain criteria and return the corresponding results (SearchResults).
    In order to have a nice presentation, I inserted this to my macro:

    Please Login or Register  to view this content.
    However, it sort all the blank cells at the top of the data. Is there a way to make all these blank cells to the bottom of the data instead? Because deleting them manually is not practical as the real database will have about 5000 entries. I've tried filter but it is not practical as well, as I'll need to reset a filter after everytime I've done a query (SearchEngine). I've also tried using delete empty rows code but doesn't work.

    Any help is very much appreciated.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-07-2012
    Location
    SG
    MS-Off Ver
    Excel 2007
    Posts
    37

    Re: Macro to bring empty cells of SearchResults to the bottom

    I've found the answer.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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