Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
keyboard shortcut for fontcolor change in excel2002 version? | Excel Discussion (Misc queries) | |||
Sum the values of cells based on fontcolor | Excel Worksheet Functions | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
Can I sort by Range Name? | Excel Discussion (Misc queries) | |||
Sort range changes during sort | Excel Discussion (Misc queries) |