Right now, I copy two cells on one sheet, into another sheet's two cells. That works fine. I don't want the formatting to transfer over though, just the values. Also, I don't want to be brought to the new sheet after the paste has been performed.
Can someone offer advice please?
![]()
Sub Defending_Blue_1() Sheets("Battling_Teams").Range("A2").Copy Sheets("Forecast").Range("A5") Sheets("Battling_Teams").Range("B3").Copy Sheets("Forecast").Range("A6") End Sub
Bookmarks