This is one way to make a range out of two pieces:

Sub rangeRover()
Set r = Range("A1:A10,C1:C4")
r.Select
End Sub

--
Gary''s Student - gsnu200850


"ker_01" wrote:

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