Excelnewbie001
Board Regular
- Joined
- Jan 25, 2017
- Messages
- 79
I used the macro recorder on a protected sheet to copy and paste and I am getting the following error if someone can please tell me how to get rid of it please....thanks for any help
Code:
Wb.Sheets("Test1").Range("F5:H5").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Test").Select
Sheets("Test").Unprotect "Test12"
Range("J2").Select
[COLOR=#ff0000] Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False[/COLOR]
Sheets("Test").Select
Range("D2").Select
Last edited: