First, at the top of the code module, have this line:

OPTION EXPLICIT

this will force you to explicitly dim variables

Next, its difficult without seeing your code but

Dim sit as String
sit = Activesheet.Name

Now often, when I see that error message its a bit of a
red herring in that a key word is often highlighted that
has no relevence to the issue....which may be that a
reference is missing. in teh IDE, select Tools/References
& check if any are flagged as Missing. If they are, then
you'll need to browse & re-select them.

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
when asking to set a variable example:
sit = ActiveSheet.name

We get a compile error that says:

Can't find library or project

What does this mean and how do we correct it. The
project
and libary are there and available, but the variable
will
not set.
.