Hello all. Below is a snippet I need help with. I looked through the Forum and tried the suggestions as indicated below, but none of them work. The formula is located in cells on the ("Uniform Order Sheet") and I want only the VALUE copied and pasted to the ("UniformBuild") sheet. The suggestions popup various errors. I think it may just the position of the PASTE section if the line that is the issue but I have tried without success to move it.
With Sheets("Uniform Order Sheet")
.Range("AA" & Rw).Copy Sheets("UniformBuild").Range("T8").PasteSpecial xlValues
.Range("AF" & Rw).Copy Sheets("UniformBuild").Range("T9").PasteSpecial Paste:=xlPasteValues
.Range("AK" & Rw).Copy Sheets("UniformBuild").Range("T10").PasteSpecial xlPasteValues
.Range("AP" & Rw).Copy Sheets("UniformBuild").Range("T11").Value = .Value
End With
Thanks,
Andrew
Bookmarks