Working with Excel Ranges

A range represents a single cell, an entire row, a whole column, a contiguous block of cells, or a three‑dimensional (3‑D) range that spans multiple worksheets.

Working with ranges on an Excel file

• Get Named Ranges inside the Workbook – Retrieves all named ranges defined in a workbook, returning their addresses and scope.
• Get Cells Data Based on Named Range – Returns the values of cells that belong to a specified named range.
• Change Heights of Rows inside the Range – Adjusts the height of each row that falls within the given range.
• Change Widths of Columns inside the Range – Modifies the column width for all columns intersecting the range.
• Combine a Range of Cells into a Single Cell – Merges the selected cells into one cell, preserving the top‑left value.
• Copy Range in a Worksheet with Paste Options – Copies a source range to a destination range with optional paste types (values, formats, formulas, etc.).
• Set the Style of the Range – Applies font, fill, border, and alignment styles to every cell in the range.
• Unmerge Merged Cells of the Range – Reverses a previous merge operation, restoring the original individual cells.
• Move a Named Range with an Excel Worksheet – Relocates a named range to a new address within the same worksheet or to another worksheet.
• Set Range Value in Excel Worksheet – Writes a single value or an array of values to the specified range.