https://community.blueprism.com/t5/University-Forum/Excel-Copy-and-Paste-Special/m-p/101533#M3426 Hello,<BR /><BR />Apologies if this is not the correct thread.<BR /><BR />Looking for some insights into the Excel Copy and Paste - Special.<BR /><BR />More specifically on the ability to Copy a data set/range from one workbook, to another workbook, copying everything in that range, except the 'visibility' of the formulas in certain cells.<BR /><BR />Ie: The origin workbook contains VLookup, etc. I do not want that showing or copied across to the new workbook.<BR /><BR />Thanks in advance. Wed, 22 Sep 2021 22:54:10 GMT douglas_denmuld 2021-09-22T22:54:10Z https://community.blueprism.com/t5/University-Forum/Excel-Copy-and-Paste-Special/m-p/101533#M3426 Hello,<BR /><BR />Apologies if this is not the correct thread.<BR /><BR />Looking for some insights into the Excel Copy and Paste - Special.<BR /><BR />More specifically on the ability to Copy a data set/range from one workbook, to another workbook, copying everything in that range, except the 'visibility' of the formulas in certain cells.<BR /><BR />Ie: The origin workbook contains VLookup, etc. I do not want that showing or copied across to the new workbook.<BR /><BR />Thanks in advance. Wed, 22 Sep 2021 22:54:10 GMT https://community.blueprism.com/t5/University-Forum/Excel-Copy-and-Paste-Special/m-p/101533#M3426 douglas_denmuld 2021-09-22T22:54:10Z https://community.blueprism.com/t5/University-Forum/Excel-Copy-and-Paste-Special/m-p/101534#M3427 Hello,<BR /><BR />Yes, we can achieve this, You need to modify/create a new code stage with the paste special method so that you don't get any formula copied to the target excel sheet.<BR /><BR />below is the one for your reference.<BR /><BR /><BR /><STRONG>.Range(source_range).Copy</STRONG><BR /><STRONG>.Range(dest_range).PasteSpecial (Paste:=xlPasteValues)<BR /><BR /><BR /></STRONG> Thu, 23 Sep 2021 02:24:35 GMT https://community.blueprism.com/t5/University-Forum/Excel-Copy-and-Paste-Special/m-p/101534#M3427 krishna.kodimurali9 2021-09-23T02:24:35Z