When a table is made up with some cells framed in or underlined the structure seems to be static and does not move along with the content when sorting. Is it possible to really attach frames/ lines to a cell so it will move along? The content of the cells are not numerical.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
moving cell lines/frames together with content when sorting
- Thread starter NickLe
- Start date
XLGibbs
Well-known Member
- Joined
- Feb 25, 2005
- Messages
- 2,446
I don't believe the borders property will move with the cells after sorting, however, if you wanted the action to be done via VB macro, it could be handled...but in the standard scope of using excels sorting feature, it simply reorganizes the contents of the cells (i.e. the Value or Formula property of the cell) whereas the border is a different property and is anchored to the specific cell address.
You can move the border using cut and paste, but that will not work real well with sorting unless you are doing it manually via the cut and paste.
You can move the border using cut and paste, but that will not work real well with sorting unless you are doing it manually via the cut and paste.
Upvote
0
