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?

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