View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default "Or" statement not working

<<Please explain what a TRIM issue is.
I forgot to also mention that there are several TRIM functions in the
Strings class in VBA. Open the Object Browser, type Trim in the Search Text
drop-down combo box, select any of the Members returned in the Search
Results pane, and click <F1 to bring up VBA Help on that Member.

For example, the Strings class has the following Members:
LTrim
LTrim$
RTrim
RTrim$
Trim
Trim$

The Excel WorksheetFunction class has the following Members:
Trim
TrimMean (not applicable in this situation)

--
Regards,
Bill Renaud