Hi Mike,

Why would missing solver.xla have anything to do with "Format"?

It is typical of missing references that (apparently) random functions are
highlighted.

How do I enable it other than re-inserting the disk (I guess I could dig
it up somewhere)?

Use Start | Find to locate the path to Solver.XLA and then , as befo

Tools | References | Browse | Navigate to Solver.XLA


---
Regards,
Norman



"mike allen" wrote in message
...
Solver.xla was missing. I don't know why. I use solver in other code for
another sheet, but it doesn't work anymore (I guess b/c solver.xla is
missing).

Why would missing solver.xla have anything to do with "Format"? or is it
just saying, in general, that something is wrong, not necessarily with
"Format"?

Also, how could I be missing solver.xla when I use it fairly often in this
file? How do I enable it other than re-inserting the disk (I guess I
could dig it up somewhere)?

Thanks, Mike Allen

"Norman Jones" wrote in message
...
Hi Mike,

In the VBE, with the problematic workbook's project selected, go to:
Tools | References
and look for any entries marked 'Missing'.

Uncheck these if they are not needed or use the browse button to locate
the reference.


---
Regards,
Norman



"mike allen" wrote in message
...
I have a function that works fine in a workbook by itself, but when I
attempt to add that function to another workbook (simply combining 2 into
1), I get an error message:

"Compile Error Can't find project or library."

then it highlights in yellow the entire function line and highlights in
blue "Format" in the line:

maturitymonth = CInt(Format(maturity, "mm"))

The odd thing is it works fine when by itself. It only does this when I
add this function into a large workbook with other functions and subs
and worksheets. Any ideas? thanks, mike allen