Compile Error: Invalid outside procedure

[ANewCoder]

I'm sure I'm overlooking something simple...but I've been getting this error message all morning and cannot figure out what I am missing...

Compile error:
Invalid outside procedure

I'm trying to implement code on my CURRENT PROJECTS tab, to move rows that have "complete" entered into column L or 12 to another tab named COMPLETED PROJECTS.

Update_to_COMPLTETED Macro
' This macro will update the CURRENT PROJECTS tab and move complete projects from column L to COMPLETED PROJECTS tab.
'
'Keyboard Shortcut: Ctrl+c
'Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 11 And Target.Value = "Complete" Then
'Define last row on completed worksheet to know where to place the row of data
LrowCompleted = Sheets("COMPLETED_PROJECTS").Cells(Rows.Count, "A").End(xlUp).Row 'Copy and paste data
Range("A" & Target.Row & ":L" & Target.Row).Copy Sheets("Completed").Range("A" & LrowCompleted + 1)
.PasteSpecial Paste:=xlPasteValues
'Delete Row from CURRENT PROJECTS
Range("A" & Target.Row & ":M" & Target.Row).Delete xlShiftUp
End If

End Sub



Any suggestions?

[DavidBowman]

Not sure about the error but there are a couple of obvious things you should take a look at:

One place you have the sheet named: Sheets("COMPLETED_PROJECTS")

In another place you have the sheet named: Sheets("Completed")

]You also don't identify the Current Projects sheet when deleting the row. Is it possible you didn't paste all of the code in the question?

[ANewCoder]

DavidBowman - thank you for your reply! As a newbie..... I do apologize for the mistakes.

In another place you have the sheet named: Sheets("Completed") Here I am trying to copy/paste/delete the row from CURRENT to COMPLETED - should I use something other than Sheets?

You also don't identify the Current Projects sheet when deleting the row. Is it possible you didn't paste all of the code in the question? I've been working on this so long today that somehow I managed to remove the last portion of my code!!! Time to go home I guess

[DavidBowman]

Sheets is okay but the name of it should be consistent - either "COMPLETED_PROJECTS" or "Completed" surely you don't have two sheets with those two different names that you are copying between? If you have referenced a worksheet that doesn't exist it can cause error.s