Copy/Paste Range: The sheet does not exist

copy paste range


Check that the name of the sheet in the activity is the one you have in Excel.

Check this:


I want to copy the range O1:P2 from sheet 2 and paste into sheet 6 but in A1 cell only./ i want all the copied data to be saved in A1 cell only. so that i can use this stored variable name into type into text activity.

Then you can use the Read Range activity with that range (O1:P2) and with sheet 2.

Then you can use the “Output Data Table” activity to convert the data table into a string and finally the write cell activity to write the above result in cell A1 of sheet 6.
(Try formatting the result of the data table to one that better suits your needs if you are not convinced by the result.)