Excel Copy and Paste - Special
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-09-21 11:54 PM
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.
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.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
23-09-21 03:24 AM
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)
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)
