⚫Deconstruct Range

Deconstruct a Range into it's Cells

Description

Deconstruct a Range into it's Cells

Preview

Location

Name | Deconstruct Range

Nickname | De Rng

Tab | ExcelPlus

Panel | Range

Division | 2

Inputs

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

A | Active (bool) | Return only active cells. If true Flip (F) input will be ignored

F | Flip (bool) | If true, cells are listed by column. If false, by row

Outputs

Rng | Range (range) | An Excel Range Object

Cel | Cell (cell) | A Cell or Address (ex. A1)

A | Address (string) | The Range address

Mode

none

Usage