Last Updated: Mar 15, 2021
Use this function to copy the values and metadata from the given input range and provides the ouput in an XML format.
Copy Entire Data (source_sheet, source_range, destination_sheet, destination_cell, paste_type)
| Input Parameter Name | Description | 
|---|---|
| range | Range of cells (first cell and last cell) separated by : to copy | 
| Return value | Description | 
|---|---|
| XML | Returns the copied data in XML format | 
Copy Entire Data (A1:B10)
To view all the Excel functions, click here.