Hi Keith

I put a coded solution to you problem at the end of your previous thread on
this matter.

--
Regards
Roger Govier

"ker_01" wrote in message
...
I'm certain that I did this some years ago, but can't recall how.

I have two separate (non-contiguous) ranges that I need Excel to see as
one
range so I can use it as the source for a data validation list.

I've tried the obvious, such as comma, semicolon, colon, ampersand, but
either my syntax is wrong, or none of those are the right way to do it.

Any suggestions?

Thanks!
Keith