Excel Copy and Paste - Special

[douglas_denmuld]

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.

[krishna.kodimurali9]

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)