Library Reference

**PosseJohn** · 01-27-2012, 08:39 PM

I brought a file home from work, and started to receive an error message from the VBA code.

Compile Error: Can't find project or library

The code that is causing the eror is "cl" in the first line:

 
            For Each cl In Target.Cells
                If IsDate(Cells(2, cl.Column)) Then
                    With Cells(2, cl.Column)
                        .Font.Bold = True
                        .Interior.Color = RGB(228, 109, 10)
                    End With
                End If
            Next

Does anyone know how to determine which library I need to enable?

Can this be automatically done through VBA when the workbook opens?

Thank you!

**TMS** · 01-27-2012, 09:11 PM

Try adding a line at the beginning of the code

Dim cl As Range

Regards, TMS

**PosseJohn** · 02-14-2012, 11:10 AM

Not a programmer by trade, I have not made a practice of this in the past, and things seem to work just fine.

What is the importance of declaring DIM for referenced objects?

Any simple answer?

Thanks.

**OnErrorGoto0** · 02-14-2012, 11:15 AM

Declaring variables is good practice. It helps you to catch typos in their names as well as acting as a data check if you specify the variable type.

For your original problem, check Tools--References in the VBEditor on the machine where the problem occurred. One of the checked references will have 'MISSING' at the start.

**TMS** · 02-15-2012, 04:59 AM

@PosseJohn:

Not a programmer by trade, I have not made a practice of this in the past, and things seem to work just fine.

and your point is? It seems that it is not the case that "things seem to work just fine". Maybe you've just been lucky.

As OEG0 says, it is good practice. Apart from anything else, it makes you think about what variables you have and what you use them for.

If you use Option Explicit and Dim all your variables, it can avoid hours of debugging time where a variable is misspelt or not initialised properly.

Regards