question

joefews-3956 asked Apr 20, '22 JiachenLiMFST-9349 edited Apr 21, '22

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

 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.