Consulting

Results 1 to 2 of 2

Thread: Solved: Sorting a column

  1. #1
    VBAX Regular
    Joined
    Nov 2008
    Posts
    41
    Location

    Solved: Sorting a column

    I tried to sort a column on a comparable basis to what I found on here. However I get a runtime error. Does anyone have an idea what could be wrong?

    shPrintout.Range("G:G").Sort Key1:=shPrintout.Range("G4")
    EDIT: I found that a Merged cell was the problem.
    Last edited by Marcke; 11-18-2008 at 01:43 PM. Reason: Solved

  2. #2
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    I avoid merged cells at all costs.......even if I risk making someone mad.......they are the cause of many problems when vba is implemented.
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

Posting Permissions

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