can't find project or library in Excel 2003 VBA

D

D Murphy

My VBA macro uses Instr and Left successfully but Mid or Right cause the
"can't find project or library" error. Mid and Right are present in the
object browser along with Left and Instr. How can I enable them?
 
F

Frank Kabel

Hi
in the VBA editor goto 'Tools - References' and make sure the Excel
library is checked
 
S

Stephen Bullen

Hi D,
My VBA macro uses Instr and Left successfully but Mid or Right cause the
"can't find project or library" error. Mid and Right are present in the
object browser along with Left and Instr. How can I enable them?
Click to expand...

Go to Tools > References and untick the ones labelled 'MISSING:'

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk
 
Top