LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default VBA sort range with certain fontcolor

Hi all,

Ik column K there will be a continuous range of which all cells have a
certain fontcolor, the font color code is, say, 5. The range can be 1 cell up
to 30 (or so), perhaps even zero. There are no cells in column K outside that
range that also have font color code 5.
While executing the code it is not (yet) known what the rownumbers of the
first and last cells in that range are.

I need code that will sort (descending) the following range:

from row of first cell (in column K) with font color code 5 and column A
to
row of last cell (in column K) with font color code 5 and column AV. Of
course no sorting if none of the cells in column K have font color code 5.

I can't figure out the code, so I need your assistance, which will be
appreciated very much.

--
Jack Sons
The Netherlands
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
keyboard shortcut for fontcolor change in excel2002 version? gulam Excel Discussion (Misc queries) 2 November 9th 08 10:31 PM
Sum the values of cells based on fontcolor [email protected] Excel Worksheet Functions 1 March 28th 08 02:51 PM
formula to sort a range so that it matches the exact rows of a column that is outside that range? steveo Excel Discussion (Misc queries) 1 June 18th 06 02:05 AM
Can I sort by Range Name? DeepSouthRick Excel Discussion (Misc queries) 1 June 2nd 05 03:06 AM
Sort range changes during sort coffedrinker2003 Excel Discussion (Misc queries) 1 May 24th 05 11:53 PM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"