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

Sub Ranges

Returns a list of Ranges for each Column or Row

PreviousRange ExtentsNextMerge Ranges

Last updated 1 year ago

Description

Returns a list of Ranges for each Column or Row

Name | Sub Ranges

Nickname | Sub Rng

Tab | ExcelPlus

Panel | Range

Division | 3

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

C | By Column (bool) | If true, Ranges will be returned by Column. If false, by Row

Rng | Range (range) | Excel Range Objects

none

Usage

🛠️
⚫