Macro stopped working for no reason

[Obewan]

I have been using the same Macro for ages and occasionally it says it has an issue and I have managed to fix it by deleting pages then adding them back and so on. This time I can't - it stops here at the bold text saying
"
Invalid forward reference:, or reference to uncompiled type."

Sub FullFilter()
'
' FullFilter Macro
'

'

Range("R1:Al1").Select
Application.CutCopyMode = False
Selection.AutoFilter
ActiveSheet.Range("$R$1:$Al$4250").AutoFilter Field:=5, Criteria1:="<>"


Just doesn't make sense - anu suggestions?

regards

Seamus

 

[Obewan]

Further to this all my macros have disappeared from the list when I click on the macros icon?

 

[Obewan]

I fixed it - has to delete sheet, then another, then another and add them back and finally worked.