View Full Version : Paste without source file name
Bob789
12-26-2020, 07:10 PM
In Excel 2019 how do you paste all content copied from one sheet in a source file to a sheet in a new file without the the source file name showing up in the pasted formulas
p45cal
12-27-2020, 06:04 AM
Do you want the formulas at all?; will plain values do?
Bob789
12-28-2020, 01:19 PM
Need the formulas
EirikDaude
12-29-2020, 06:16 AM
Would
Workbooks("Destination").Worksheets("Destination").Range("Whatever").Formula = Workbooks("Source").Worksheets("Source").Range("Whatever").Formula
do the trick for you?
Or are you looking for a way to do it without VBA?
Bob789
12-29-2020, 07:25 AM
Preferably without vba. Just copy past
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.