Results 1 to 10 of 19

Thread: Sort Range Using VBA And Ignoring Or Discarding Blank Rows

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-05-2014, 05:34 PM #10
    analyst
    analyst is offline
    Member
    Join Date
    Aug 2013
    Posts
    59
    Rep Power
    13
    Thanks for looking at here. The File with original simple vanila macro is attached herewith.

    Just run the macro named 'sort', and see the result in range AE3:AP17

    Original data, which are derived through Formulas are in range R3:AC17
    Attached Files Attached Files
    Last edited by analyst; 02-05-2014 at 05:37 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Delete blank rows
    By dhivya.enjoy in forum Excel Help
    Replies: 5
    Last Post: 10-23-2013, 10:04 PM
  2. Insert blank rows based on cell value
    By muhammad susanto in forum Excel Help
    Replies: 13
    Last Post: 09-11-2013, 06:18 AM
  3. Sort Data By Multiple Columns And Delete Some Rows Based On Criteria
    By valesilver in forum Excel Help
    Replies: 6
    Last Post: 08-14-2013, 04:25 PM
  4. Selecting/deselecting rows - then sort & Hide/Unhide rows
    By Rasm in forum Download Center
    Replies: 2
    Last Post: 05-06-2011, 02:59 AM
  5. Deleting blank rows
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-14-2011, 03:14 AM

Tags for this Thread

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
  •  

Forum Rules