Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Problems sorting from VB when some rows include Borders property

Is there a secret to sorting data after some of the rows have been
highlighted with the Borders property? It seems that all other
formatting moves with the cell (ex. Bold, Font, Size, InteriorColor)
but when a I have added a border box selectively around a series of
cells on various rows, the boxes remain where they were prior to the
sort.

Is there a way to keep the Borders attribute with the data that it
surrounds when doing a sort?

Thanks,
-Bruce

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
Sorting Column A & Include date in the Entire Row sgreene1 Excel Discussion (Misc queries) 2 November 10th 09 03:18 PM
Sort rows and move borders with rows [email protected] New Users to Excel 1 June 4th 09 07:36 AM
Sorting a range loses formatted borders Jim Cone Excel Discussion (Misc queries) 2 February 25th 08 07:58 PM
Sorting to Include Blank Rows Robert M Excel Discussion (Misc queries) 2 July 14th 07 12:57 PM
sorting, borders going with cell content Jack Sons Excel Discussion (Misc queries) 16 July 26th 05 01:21 PM


All times are GMT +1. The time now is 03:09 PM.

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

About Us

"It's about Microsoft Excel"