Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 25th 08, 02:41 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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 ?

  #2   Report Post  
Old February 25th 08, 07:27 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
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   Report Post  
Old February 25th 08, 07:58 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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 ?



Reply
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
If a range of cells in Excel are formatted as dates ie. (mm/dd/yy) mfoley Excel Discussion (Misc queries) 3 January 20th 07 05: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 07:13 PM


All times are GMT +1. The time now is 01:19 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017