Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting a range loses formatted borders
Excel does not include borders when sorting, no matter what Excel version you use. Also, conditionally formatted colors do not sort. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins - two dozen ways to sort with "Special Sort") "Mick Jennings" wrote in message Hi all, Recently started new job where the standard is Excel 2003 SP2. I have a worksheet which is automatically populated and formatted from VBA, based on data extracted from a directory-full of spreadsheets. All works ok, except when I sort the resulting worksheet the borders don't move. Patterns etc move fine, but the borders stay where they were, leaving an ugly mess. Exactly the same happens whether the sort is triggered from code or from the menus. Anyone seen this before ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting a range loses formatted borders
Thanks Jim. A few separate experiments confirms that. Seems a major oversight
to me, but at least I know. "Jim Cone" wrote: Excel does not include borders when sorting, no matter what Excel version you use. Also, conditionally formatted colors do not sort. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins - two dozen ways to sort with "Special Sort") "Mick Jennings" wrote in message Hi all, Recently started new job where the standard is Excel 2003 SP2. I have a worksheet which is automatically populated and formatted from VBA, based on data extracted from a directory-full of spreadsheets. All works ok, except when I sort the resulting worksheet the borders don't move. Patterns etc move fine, but the borders stay where they were, leaving an ugly mess. Exactly the same happens whether the sort is triggered from code or from the menus. Anyone seen this before ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting a range loses formatted borders
Maybe an oversight; ...MS hears a different drummer. <g My Special Sort add-in didn't overlook it. Direct download at my website for the free 3 week trial. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Mick Jennings" wrote in message Thanks Jim. A few separate experiments confirms that. Seems a major oversight to me, but at least I know. "Jim Cone" wrote: Excel does not include borders when sorting, no matter what Excel version you use. Also, conditionally formatted colors do not sort. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins - two dozen ways to sort with "Special Sort") "Mick Jennings" wrote in message Hi all, Recently started new job where the standard is Excel 2003 SP2. I have a worksheet which is automatically populated and formatted from VBA, based on data extracted from a directory-full of spreadsheets. All works ok, except when I sort the resulting worksheet the borders don't move. Patterns etc move fine, but the borders stay where they were, leaving an ugly mess. Exactly the same happens whether the sort is triggered from code or from the menus. Anyone seen this before ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If a range of cells in Excel are formatted as dates ie. (mm/dd/yy) | Excel Discussion (Misc queries) | |||
Sorting loses links to data | Links and Linking in Excel | |||
Sorting formatted numbers | Excel Discussion (Misc queries) | |||
sorting, borders going with cell content | Excel Discussion (Misc queries) | |||
Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions |