Trim not working....
 

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

--
FlatEri
-----------------------------------------------------------------------
FlatEric's Profile: http://www.excelforum.com/member.php...fo&userid=3176
View this thread: http://www.excelforum.com/showthread.php?threadid=51483

Trim not working....
 

Check whether there are any reference problems (ToolsReferences) in the
VBIDE. If any items are MISSING, uncheck them.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"FlatEric" wrote in
message ...

Hi,

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


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


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

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

Can anyone shed any light on this pls.


Thx
Mark.


--
FlatEric
------------------------------------------------------------------------
FlatEric's Profile:
http://www.excelforum.com/member.php...o&userid=31760
View this thread: http://www.excelforum.com/showthread...hreadid=514839

Trim not working....
 

Bob,

That fixed it. :) Thanks very much for your very prompt help.

Kind regards
Mark.


--
FlatEric
------------------------------------------------------------------------
FlatEric's Profile: http://www.excelforum.com/member.php...o&userid=31760
View this thread: http://www.excelforum.com/showthread...hreadid=514839