Thread: RUNTIME ERROR: 1004, Paste Special

Hi,

I have created a task manager workbook that I now seem to have a problem with.
This is the first VBA scripted one I have created and everything worked well until I started to get a runtime error 1004: Pastespecial...

I have a feeling the problem lies with some code ahead of the actual pastespecial method.

Just a note: The workbook VBA has a protect workbook function with password but I never had an issue with the pasting funtion in a protected worksheet before.

Sub Button1_Click()
'
' Button1 Macro
'

  If Worksheets("Task Selector").Range("A1") = "Admin" Then

    Range("X11:AD11").Select
    Selection.Copy
    Sheets("Admin").Select
    Range("B3").Select
    NextRow = Range("B65536").End(xlUp).Row + 1
    Range("B" & NextRow).Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Sheets("Control Panel").Select
    
   End If
    
    End Sub

Your help will be greatly appreciated!