# Copy Paste Range

> `UiPath.GSuite.Activities.CopyPasteRange`

`UiPath.GSuite.Activities.CopyPasteRange`

## Description

Copies and pastes a range of specified cells into a specified sheet. You can copy from sheet and paste into a different one, or copy and paste within the same sheet.
:::note
This classic activity is in maintenance mode. Instead, use the modern equivalent, the [Copy Paste Range](https://docs.uipath.com/activities/other/latest/productivity/google-workspace-copy-paste-range) activity.
:::

### Scopes

This activity requires the following scopes:

* https://www.googleapis.com/auth/drive

OR

* https://www.googleapis.com/auth/spreadsheets

## Project compatibility

Windows - Legacy | Windows

## Configuration

**Properties**

#### Common

* **ContinueOnError** - If set, the remaining activities are executed if the current activity fails. This field supports Boolean values.
* **DisplayName** - The display name of the activity. This property supports `String` variables and string formatted values.

#### **Destination**

* **StartingCell** - The cell where you want to begin pasting your copied data. This property supports `String` variables and string formatted values (enter your range in A1-style notation). The default value is "C3".
* **ToSheetName** - The name of the sheet that you want to paste data into. This property supports `String` variables and string formatted values.

#### Input

* **SpreadSheetID** - The ID of the spreadsheet that contains the sheet you want to paste data into. This property supports `String` variables and string formatted values. When entering your value, use the exact ID, or the output property variable from a previous [Find Files And Folders](https://docs.uipath.com/activities/other/latest/productivity/gsuite-find-files) or [Copy File](https://docs.uipath.com/activities/other/latest/productivity/gsuite-copy-drive-file) activity.

#### Options

* **PasteOrientation** - The orientation of the paste date. There are two options: **NORMAL** and **TRANSPOSE**.
  + The **TRANSPOSE** option indicates that the copied rows will paste as columns and the copied columns paste as rows.
* **PasteType** - The format to paste the copied data. Select from the following options:
  + **PASTE_NORMAL**: Paste values, formulas, formats and merges.
  + **PASTE_VALUES**: Paste values only, without formulas, formats and merges.
  + **PASTE_FORMAT**: Pastes format and data validation only.
  + **PASTE_NO_BORDERS**: Pastes values, formulas, formats and merges, all without borders.
  + **PASTE_FORMULA**: Pastes the formula only.
  + **PASTE_DATA_VALIDATION**: Pastes data validation only.
  + **PASTE_CONDITIONAL_FORMATING** - Pastes the conditional formatting only.

#### Source

* **FromSheetName** - The name of the sheet that you want to copy data from. This property supports `String` variables and string formatted values. The default value is "Sheet1".
* **Range** - Specifies the range of cells that you want to copy. This property supports `String` variables and string formatted values (enter your range in A1-style notation). The default value is "A1:B2".

  + For example, if you have data in cells A1:C4, and you enter "A1:B3" as your **Range**, the data in cells A1:B3 is copied and the data in cells A4, B4, and C1:C4 remains.

#### Misc

* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.