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