Guys thanks for the replies!, Don i would like to use your suggestion as
an add-in is not an option because i would have to install the add-in on
every machine, could you give me a hand on how to use what you have
supplied......i did try adding it to a w/s but didnt actually get what
i needed, probably because the way i was using it

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=571172