Search

Copy Values As Table(Dep.)

Articles

This function is deprecated.

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 (Dep.) (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 (Dep.) (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?