View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lwm lwm is offline
external usenet poster
 
Posts: 38
Default Data form errror

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