+ Reply to Thread
Results 1 to 3 of 3

VBA to sort column descending - can't get it right!

  1. #1
    Forum Contributor
    Join Date
    02-08-2006
    Location
    UK
    MS-Off Ver
    2013
    Posts
    204

    VBA to sort column descending - can't get it right!

    Morning.

    I have a table with columns A to H and an unknown number of rows (Row 1 containing headers). The table is named as "Rng".


    Column B contains numbers and I want to sort column B in descending order. I've tried several examples but they don't work for me as they all seem to work for me. I've tried recording a macro but that fails as well and it is, frankly, doing my nut in!

    Please Login or Register  to view this content.
    Last edited by wonderdunder; 07-18-2011 at 04:29 AM.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: VBA to sort column descending - can't get it right!

    Try:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    02-08-2006
    Location
    UK
    MS-Off Ver
    2013
    Posts
    204

    Re: VBA to sort column descending - can't get it right!

    Done the job nicely! Many thanks

+ 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