Well, I've learnt quite a bit And all is very handy stuff

As it turned out Bob gave me the right answer for my situation th
fisrt time round.
I had trimmed off the first part and because my form has model=Fals
whenever i changed worksheets the combobox rowsource changed.
Thanks alot for the help guys
CA

--
Message posted from http://www.ExcelForum.com