Hi,
I have below code where i'd like to copy AG21, W22 and AB22 from Sheets("ST") and paste to same cell location in every worksheet excluding "Summary" an "ST". Can anyone help me modify the code as it is not working currently
I have below code where i'd like to copy AG21, W22 and AB22 from Sheets("ST") and paste to same cell location in every worksheet excluding "Summary" an "ST". Can anyone help me modify the code as it is not working currently
VBA Code:
Option Explicit
Sub TEST()
Dim sht As Worksheet
Sheets ("ST").Range("AG21").Copy
Sheets ("ST").Range("W22").Copy
Sheets ("ST").Range("AB22").Copy
Selection.Range("AG21").PasteSpecial xlPasteValues
Selection.Range("W22").PasteSpecial xlPasteValues
Selection.Range("AB22").PasteSpecial xlPasteValues
Application.CutCopyMode = False
End Sub