Split Range By Column

Split a range into a list of per-column lists.

ExcelExcelSplitRangeByColumn

What it does

Split a range into a list of per-column lists.

Parameters

ParameterTypeRequiredDefaultDescription
Excel instancevariable
RequiredexcelName that identifies this open workbook.
Sheet (blank = active)string
OptionalWorksheet name; blank uses the active sheet.
Supports variables
Range (A1:C3)string
Required
Example: A1:C10
Supports variables
Store columns invariable
Required
Example: columns

More Excel commands

Ready to automate your busywork?

Start your free 10-day trial today. No credit card, no commitment.