"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
|