Search

Get Table Range

Last Updated: Dec 1, 2020

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 that the table exists

Sample

Get Table Range (Table1) => B3:E7

  • Gets the the excel range of the table ‘Table1’ from the active spreadsheet and returns the range of the cells.

To view all the Excel functions, click here.

Did you find what you were looking for?