Excel Plus
  • 👋Welcome
  • 🛠️Components
    • Analysis
      • ⚫Add Spark Bar
      • ⚫Add Spark Line
      • ⚫Conditional Bars
      • ⚫Conditional Between
      • ⚫Conditional Blank
      • ⚫Conditional Percent
      • ⚫Conditional Scale
      • ⚫Conditional Text
      • ⚫Conditional Top
      • ⚫Conditional Unique
      • ⚫Conditional Value
    • Cell
      • ⚫Cell Content
      • ⚫Cell Address
      • ⚫Cell Location
      • ⚫Generate Cells
    • Format
      • ⚫Border
      • ⚫Clear
      • ⚫Fill
      • ⚫Font
      • ⚫Size
    • Range
      • ⚫Construct Range
      • ⚫New Range
      • ⚫Populate Range
      • ⚫Deconstruct Range
      • ⚫Explode Range
      • ⚫Range Extents
      • ⚫Sub Ranges
      • ⚫Merge Ranges
    • Worksheet
      • ⚫Construct Worksheet
      • ⚫Deconstruct Worksheet
      • ⚫Worksheet Properties
      • ⚫Place Image
    • Workbook
      • ⚫Construct Workbook
      • ⚫Deconstruct Workbook
      • ⚫Workbook Properties
      • ⚫Open Workbook
      • ⚫Save Workbook
      • ⚫Read Workbook
      • ⚫Write Workbook
Powered by GitBook
On this page
  • Description
  • Usage
  1. Components
  2. Range

Merge Ranges

Merge or unmerge a Range

PreviousSub RangesNextWorksheet

Last updated 1 year ago

Description

Merge or unmerge a Range

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

Name | Merge Ranges

Nickname | Merge Rng

Tab | ExcelPlus

Panel | Range

Division | 4

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.

Rng | Range (range) | An Excel Range Object

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

none

Usage

🛠️
⚫