Thanks ever so much everyone it has really helped me out. I went for
mphell's solutution and it seems to have worked, im ecstatic! I really
am thankfull to all of you who helped me out on this one, i cant
express how much of a pain this has been for me and im so glad to have
got it sorted before the weekend!

Once again many thanks, i really appreciate it.

Cheers

-Andy


--
andrewsnaith
------------------------------------------------------------------------
andrewsnaith's Profile: http://www.excelforum.com/member.php...o&userid=32110
View this thread: http://www.excelforum.com/showthread...hreadid=518673