I keep receiving ..... Can't find project or library on the following
line.

If Left$(UCase$(response), 1) = "D" Then

This macro works fine on other computers and had been working fine
until recently. What is missing on this computer?

TIA
Gerry

Open excel on the troublesome pc
Open your workbook
Go into the VBE
Select your project
Tools|References
Look for MISSING reference.

Uncheck that missing reference.

The missing reference may not (usually doesn't) have anything to do with the
line that caused the error.

If you're not using that reference, you can go back to your pc and remove it and
then redistribute the workbook.

If you're using that reference, you'll have more work to do for the troublesome
pc's.

Gerry wrote:
>
> I keep receiving ..... Can't find project or library on the following
> line.
>
> If Left$(UCase$(response), 1) = "D" Then
>
> This macro works fine on other computers and had been working fine
> until recently. What is missing on this computer?
>
> TIA
> Gerry

--

Dave Peterson

Take a look at this:
http://www.cpearson.com/excel/References.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Dave Peterson" wrote:

> Open excel on the troublesome pc
> Open your workbook
> Go into the VBE
> Select your project
> Tools|References
> Look for MISSING reference.
>
> Uncheck that missing reference.
>
> The missing reference may not (usually doesn't) have anything to do with the
> line that caused the error.
>
> If you're not using that reference, you can go back to your pc and remove it and
> then redistribute the workbook.
>
> If you're using that reference, you'll have more work to do for the troublesome
> pc's.
>
> Gerry wrote:
> >
> > I keep receiving ..... Can't find project or library on the following
> > line.
> >
> > If Left$(UCase$(response), 1) = "D" Then
> >
> > This macro works fine on other computers and had been working fine
> > until recently. What is missing on this computer?
> >
> > TIA
> > Gerry
>
> --
>
> Dave Peterson
>

On Aug 12, 12:07*pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> Open excel on the troublesome pc
> Open your workbook
> Go into the VBE
> Select your project
> Tools|References
> Look for MISSING reference.
>
> Uncheck that missing reference. *
>
> The missing reference may not (usually doesn't) have anything to do with the
> line that caused the error.
>
> If you're not using that reference, you can go back to your pc and removeit and
> then redistribute the workbook.
>
> If you're using that reference, you'll have more work to do for the troublesome
> pc's.
>
> Gerry wrote:
>
> > I keep receiving ..... Can't find project or library on the following
> > line.
>
> > If Left$(UCase$(response), 1) = "D" Then
>
> > This macro works fine on other computers and had been working fine
> > until recently. *What is missing on this computer?
>
> > TIA
> > Gerry
>
> --
>
> Dave Peterson

Thanks Dave, that did the trick!!