This was answered yesterday.

--
Regards,
Tom Ogilvy

"Simon Lloyd"
wrote in message
...

Hi, I have sorted the first error message i got, it was a space missing
where it says "Drop Down"&i it needed a space after the word down, that
now works fine, the code works fine BUT.......the values of the Drop
Down boxes are not being copied but the row nubers that the value
refers to is being copied over......i need the values from the boxes
copying....any ideas for this?

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=544076