Results 1 to 3 of 3

Thread: Sorting (97)

  1. #1
    JGRAY12345678910
    Guest

    Sorting (97)

    Can cells, rows and/or columns be sorted by color? Thanks! <img src=/S/hello.gif border=0 alt=hello width=25 height=29>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sorting (97)

    They could be sorted but would require the use of VBA to either do the sorting or to return a value taht could be sorted. The big question is how do you want them sorted, i.e. which would come first, second etc ?. Would sorting by the color index be ok?. And is it the text color or the fill color you want sorted?

    Andrew C

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting (97)

    As Andrew said, it can be done in VBA. Maybe the answer in <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=42636&page=&view= &sb=&o=&vc=1> this thread </A> is what you want.

Posting Permissions

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