Blue Prism University

last person joined: yesterday 

A Community to discuss and learn more about Blue Prism University and certification.

 Excel Copy and Paste - Special

douglas.denmulder's profile image
douglas.denmulder posted 09-22-2021 23:55
Hello,

Apologies if this is not the correct thread.

Looking for some insights into the Excel Copy and Paste - Special.

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.

Ie: The origin workbook contains VLookup, etc. I do not want that showing or copied across to the new workbook.

Thanks in advance.
MuraliKrishna Kodi's profile image
MuraliKrishna Kodi
Hello,

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.

below is the one for your reference.


.Range(source_range).Copy
.Range(dest_range).PasteSpecial (Paste:=xlPasteValues)