⚫Merge Ranges

Merge or unmerge a Range

Description

Merge or unmerge a Range

(note: Ranges will be merged sequentially. If multiple Ranges overlap, the latter Range merge will be ignored.)

Preview

Location

Name | Merge Ranges

Nickname | Merge Rng

Tab | ExcelPlus

Panel | Range

Division | 4

Inputs

Rng | Range (range) | A Range or Address (ex. A1:B1)

M | Merge (bool) | If true, the cells in the range will be merged and only the first cells value and formatting will be applied.

Outputs

Rng | Range (range) | An Excel Range Object

M | Merged (bool) | The merge status of the Range

Mode

none

Usage