I must admit I didn't try your second first time round, but I just have, and
it has the same problem with the Str function. If you read the help on Str,
it says ... When a number is converted to a string, a leading space is
always reserved for its sign..., so it embeds a space which causes a
problem. It is just not necessary anyway, but if you do want to coerce a
number, use CStr. Also, you setup a variable called Formu, but used another
called Formu1, it would be empty. Use Option Explicit.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Cumberland" wrote
in message ...

Thanks Bob, that's great - it works fine now.

Although I have to ask - why does your method work over my second
method? Surely it's just a different way of doing the same thing?

Thanks again.


--
Cumberland
------------------------------------------------------------------------
Cumberland's Profile:
http://www.excelforum.com/member.php...o&userid=33445
View this thread: http://www.excelforum.com/showthread...hreadid=553980