how to do i copy without it copying the formulae in VBA?

joe fews 1 Reputation point
2022-04-20T12:20:28.31+00:00 
ThisWorkbook.Sheets("1042 DTS").Activate
Range("A11").Formula2 = "='" & FilePath1 & "[" & FileName1 & "]Cash Sheet'!A11"
Range("A11").Copy Destination:=Range("A11:AA272")
Range("A11:AA272").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False

i am borrowing someone else code and need it to just paste as values but it seems to paste as the formulae from cell A11, i am not sure how to fix it.

0 comments