Search

Copy Values As Table

Last Updated: Dec 28, 2022

Articles

Use this function to copy values (without metadata) to a Data Table from the specified range of the currently active excel sheet.

Syntax

Copy Values As Table (table_definition, range)

Parameters

Input Parameter Name Description
table_definition Name of the table from table definition
range First cell to last cell value separated by : to copy the values

Returns

Return value Description
Table Returns the copied data as a table type variable

Sample

Copy Values As Table (EmployeeDetails, A1:A5)

  • Copies the data present in the range A1:A5 from the sheet that is currently active to table EmployeeDetails.

To view all the Excel functions, click here.

Did you find what you were looking for?