SORTING PROBLEM . Please help
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: SORTING PROBLEM . Please help

  1. #1
    Join Date
    Jul 2014
    Posts
    2

    Post SORTING PROBLEM . Please help

    How to sort a single column without disrupting the rest of the Column ?

    Hopefully my question makes sense, I'm very tired and I've been fighting with sorting for awhile

    Please help me
    Code:
     range = sheet.Range("A1:D2000")
            range.Select()
            range.Sort(Key1:=range.Range("D1"), Order1:=Microsoft.Office.Interop.Excel.XlSortOrder.xlAscending, Orientation:=Microsoft.Office.Interop.Excel.XlSortOrientation.xlSortColumns)

  2. #2
    Join Date
    Jan 2006
    Location
    Chicago, IL
    Posts
    14,951

    Re: SORTING PROBLEM . Please help

    Record a MACRO doing the same thing, then look at the generated code. Shouldn't be hard to spot the differences
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

Tags for this Thread

Posting Permissions

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


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center