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.
Bookmarks