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?
Bookmarks