Sorry Bob
However a guru like yourself can spot these problems withou
explanation ;-)

The problem was it didn't populate my combobox.
I tried your piece of code and still nothing, so I trimmed out th
first bit and then realised that an erlier attempt only needed th
.Address at the end. Which after trimming yours was exactly what
needed.

I need to read more about the references cells, previously I had gotte
away with just "Sheet1!B50:B56" but had never ttried within an i
statement to set it at runtime, quirky stuff.

Thanks alot for your help, my day has just become lighter.
CA

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