We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Sub ReplaceData() Sheets("Sheet1").Range("A1:C32").Select Application.CutCopyMode = False Selection.Copy ActiveWindow.ActivatePrevious Sheets("Data").Select ActiveSheet.Unprotect Password:="pw" Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveSheet.Protect Password:="pw" Workbooks("Macro.xlsm").Close False End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.