PDA

View Full Version : Solved: Unusual Problem using mid and format in vba



gibbo1715
05-26-2006, 12:58 AM
Hi All

I have a very unusual problem that i ve not come across before?

I am using a spreadsheet on either office 2000 or XP and on some machines i now get an error saying library not found when using format or mid functions

Anyone have any ideas what would cause this??

Cheers

Gibbo

Bob Phillips
05-26-2006, 05:05 AM
It is usually caused by rogue type libraries. Go to Tools>References in the VBIDE, and if you have any checked items with MISSING in there, uncheck them.

gibbo1715
05-26-2006, 07:16 AM
Thanks that solved it

Gibbo