Toppers wrote:
It will merge columns too!

"bbelly" wrote:


The button "merge across" allows you to pick a group of cells, and
merges them along rows.

I need to pick a group of cells and have them merge in columns.

Perhaps someone has seen such a need, and has a code?

Thanks


Perhaps you misunderstand my request?

Given a group of cells A1 - D4, applying 'merge across' to this group
creates four merged cells ...

_________________
| A1 B1 C1 D1 |
|________________|
| A2 B2 C2 D2 |
|________________|
| A3 B3 C3 D3 |
|________________|
| A4 B4 C4 D4 |
|________________|

I want to select this group, apply 'merge up&down'( 'merge vertical),
and get four cells merged thus ...

____________________
| A1 | A2 | A3 | A4 |
| | | | |
| B1 | B2 | B3 | B4 |
| | | | |
| C1 | C2 | C3 | C4 |
| | | | |
| D1 | D2 | D3 | D4 |
|____|____|____|____|

Hope that illustrates better.