#1
|
|||
|
|||
Merge Cells with between top and bottom border
Hello,
I have a large table and i need to merge colum by column all cells that begin with the cell which has a visible top border and ends with the cell that has a visible bottom border. some cells already have top and bottom border and can be skipped. The result is for example Skip Cell1 in Column1 merge Cell2, Cell3 and Cell4 in Column1 then megre Cell 5 and 6, Skip Cell 7 and so on. I have no clue how to find and select the cells. Could someone help me please? |
#2
|
|||
|
|||
Hello!
You can use a VBA macro in Excel to perform this task. Here's some sample code that might help you: Set rng = Range("A1:E10") ' Replace "A1:E10" with the range of your table For Each cell In rng If cell.Borders(xlEdgeTop).LineStyle <> xlNone And cell.MergeCells = False Then Continue on my own, because I don’t know |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
bottom border | arvin_cool88 | Mail Merge | 0 | 02-20-2024 04:45 AM |
Bottom border on every page break | Marcia | Excel Programming | 0 | 01-30-2019 06:42 AM |
Table bottom border not performing well | herpez | Word Tables | 2 | 01-16-2017 03:43 PM |
How to extend a table bottom border to the end of the page | mikemike616 | Word VBA | 1 | 08-20-2015 08:08 PM |
Bottom border doesn't display at certain zoom | Cosmo | Word Tables | 1 | 10-09-2013 10:38 AM |