Trim not working....

  • Thread starter Thread starter FlatEric
  • Start date Start date
F

FlatEric

Hi,

I use len(trim( range("blah:blah") ) ) > 0 to test wether a cell (o
range) has contents.


Code
-------------------
If Len(Trim(Range("CopyFSAReference"))) = 0 The
-------------------


This works fine on my version of excel but when a colleague of min
runs the same spreadsheet he gets an error complaining that trim isn'
a valid function.

We are both running the same version of excel (2002) but my colleagu
has SP3 while I have sp2. I wouldn't have thought this would make an
difference especially since I'm running a slighly older service pack

Can anyone shed any light on this pls.


Thx
Mark
 
Check whether there are any reference problems (Tools>References) in the
VBIDE. If any items are MISSING, uncheck them.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top