COMPILE ERROR: Can't find project or library

[5pds]

Hi there can anyone help with the above. I am fairly new to the VBA program and have never came across this. My code is as follows if it is the problem

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("G7:K154")) Is Nothing Then
Application.EnableEvents = False
Target.Offset(, 8).Value = Time
Application.EnableEvents = True
ElseIf Not Intersect(Target, Range("A7:A154")) Is Nothing Then
Application.EnableEvents = False
Target.Offset(, 20).Value = Time
Application.EnableEvents = True
End If
End Sub

Thanks

Paul

 

[Andrew Poulsom]

Which line is causing the error? In the VBE under Tools|References, do you have any marked as MISSING?

 

[5pds]

Yeah there is one in the reference that is ticked as Missing (Ref Edit Control)

The top line in the coede is the one that is highlighted in yellow.

 

[Andrew Poulsom]

Clear the checkbox next to the missing reference.

 

[5pds]

Problem solved,

Thanks

Paul

 

[DREV]

Solved (For Me at least)
I have found many posts with solutions that did not work for me. I would uncheck the RefEDit (Missing) in VBE/Tools/References, and even reboot but it would always come back. I was having many symptoms in addition to the subject message, such as chr() & left() were undefined. The solution was to create an OFFICE10 folder in the Program Files/Microsoft Office folder and to place a copy of RefEdit.dll in OFFICE10. You may find this .dll in OFFICE11.