View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bluinenburg@ciber.com is offline
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