Search

Get Table Range

Last Updated: Dec 28, 2022

Articles

Use this function to retrieve the excel range of a table from the active spreadsheet.

Syntax

Get Table Range (table_name)

Parameters

Input Parameter Name Description
table_name Name of the table

Returns

Return value Description
Range Returns the range of the cells of the table

Sample

Get Table Range (EmployeeDetails)

  • Gets the excel range of the table EmployeeDetails from the active spreadsheet and returns the range of the cells.
    Returns B27:C31, the range of the cells of the table EmployeeDetails.

To view all the Excel functions, click here.

Did you find what you were looking for?