Click Tools/References on the VBA editor's menu bar and see if any
references are missing. If so, check the box next to them and see if that
straightens things out.

Rick


"lwm" wrote in message
...
Using this code

With Me
'make sure there's a data source, destination, and title
If Trim(.cmbDstSheet.Value) = "" Or _
Trim(.refSrcRange.Value ) = "" Or _
Trim(.txtChartTitle.Value) = "" Then


I am getting a compiler error at the word Trim that can't find project or
library

the cmbDstSheet.Value is corectly named in the form design as is the
refSrcRange.Value. If I rem out cmb I still get the same error at trim
with
ref

Any ideas ?

Thanks