A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Sorting a range loses formatted borders



 
 
Thread Tools Display Modes
  #1  
Old February 25th 08, 03:41 PM posted to microsoft.public.excel.misc
Jim Cone
external usenet poster
 
Posts: 3,290
Default 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 ?
Ads
  #2  
Old February 25th 08, 08:27 PM posted to microsoft.public.excel.misc
Mick Jennings[_2_]
external usenet poster
 
Posts: 4
Default 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  
Old February 25th 08, 08:58 PM posted to microsoft.public.excel.misc
Jim Cone
external usenet poster
 
Posts: 3,290
Default 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 ?
>

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
If a range of cells in Excel are formatted as dates ie. (mm/dd/yy) mfoley Excel Discussion (Misc queries) 3 January 20th 07 06:50 PM
Sorting loses links to data SueD Links and Linking in Excel 2 May 16th 06 09:04 AM
Sorting formatted numbers Hunter Excel Discussion (Misc queries) 2 August 31st 05 01:09 AM
sorting, borders going with cell content Jack Sons Excel Discussion (Misc queries) 16 July 26th 05 01:21 PM
Converting 'General' formatted cells to Text formatted cell using. Zahid Khan Excel Worksheet Functions 1 March 12th 05 08:13 PM


All times are GMT +1. The time now is 12:21 PM.


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