Thats excellent Kevin , very much appreciated - worked first time

Can you just clarify what you meant about the space in the sheet name.
How does that alter the formula you gave. Is it the gap between the &
and the A2 you are talking about ? This will help me understand it
better.

One last thing, what difference do the $ signs make ?

Omce again many thanks

Darren


--
DarrenWood
------------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460
View this thread: http://www.excelforum.com/showthread...hreadid=510703