• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 426
  • Last Modified:

VBA - "Can't Find Project Or Library"

Hi,
I have some moderate knowledge of VBA - not great tho!

I am trying to fix something for a colleague.
At this moment, I cannot upload the sheet onto EE.

Someone send me a workbook.

When I try to compile to VBA I get "Can't find project or Library".

This line is the problem!
NM = MsgBox("Data has been clear", vbOKOnly, "New Month")

There appear to be no other reference in the VBA to "NM".



Sub NewMonth()
    Application.ScreenUpdating = False
    Sheet48.Select
    Range("GoTo1").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    Range(Selection, Selection.End(xlToLeft)).Select
    Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
    Range("A1").Select
    Sheet38.Select
    Range("EvaDailyData").Select
    Selection.ClearContents
    Range("A1").Select
    Sheet29.Select
    Application.ScreenUpdating = True
    NM = MsgBox("Data has been clear", vbOKOnly, "New Month")
End Sub
0
Patrick O'Dea
Asked:
Patrick O'Dea
  • 2
1 Solution
 
MacroShadowCommented:
Check for missing references. alternatively you can try VBA.MsgBox.
0
 
Patrick O'DeaAuthor Commented:
Thanks ... I am closing this call as I have raised a similar (perhaps better) one.
0
 
Saqib Husain, SyedEngineerCommented:
Go to

Tools > References

and look for a ticked item starting with "Missing:...."
0
 
MacroShadowCommented:
Check for missing references.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now