I have changed from one machine to another recently and have started
getting a "Compile Error"
"Can't find project or library "
unexplainedly when I run a routine (that worked on the old machine).
I am using Office Professional 2003 on Windows XP.

The compile error occurs on the VBA statement:
currow = Int(Mid(ActiveCell.Address, locrowt1 + 1))

The problem appears to be that the Mid function is not being
recognized as a valid function. In this spreadsheet, whenever I
type "MID(" no autocomplete help shows as it does, for example if I
type "Instr(". This suggests that something is corrupted the
recognition of the built-in function "Mid".

If I create a new spreadsheet, and place the same statement in a
routine, then all is fine.