+ Reply to Thread
Results 1 to 3 of 3

Trim not working....

Hybrid View

  1. #1
    Registered User
    Join Date
    02-21-2006
    Posts
    2

    Trim not working....

    Hi,

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

    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.

  2. #2
    Bob Phillips
    Guest

    Re: Trim not working....

    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
    >




  3. #3
    Registered User
    Join Date
    02-21-2006
    Posts
    2
    Bob,

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

    Kind regards
    Mark.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1