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
  1. Components
  2. Range

Explode Range

Explode all Cells in a Range into individual Ranges

PreviousDeconstruct RangeNextRange Extents

Last updated 1 year ago

Description

Explode all Cells in a Range into individual Ranges

Name | Explode Range

Nickname | Explode Rng

Tab | ExcelPlus

Panel | Range

Division | 3

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

A | Active (bool) | If true, only the active cells in the range will be returned

Rng | Range (range) | Excel Range Objects

none

Usage

🛠️
⚫
  • Description
  • Usage