Trim not working....

Hi,

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

Please Login or Register  to view this content.

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.

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)

"FlatEric" <FlatEric.23kvhn_1140522902.7935@excelforum-nospam.com> wrote in
message news:FlatEric.23kvhn_1140522902.7935@excelforum-nospam.com...
>
> 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
>

Bob,

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

Kind regards
Mark.