"Building" Ranges from Smaller Ranges

[Ark68]

Is it possible to "build" a range?
I have a column of cells with values in them (H9:H42).
I set ranges using a series of contingent cells in that range. These set ranges become the source of my named ranges which I use as data validation list sources.

Dim rng_biscuits as range
Dim rng_flowers as range
Dim combined as range

Set rng_biscuits = worksheets(sheet1).range("H9:H12")
Set rng_flowers = worksheets(sheet1).range("H30:H42")

Both rng_biscuits and rng_flowers may become the source range for a named range used in a list data validation.

Suppose I want my data validation list to be a combination of both ranges H9:H12 and H30:H42?

I tried

set combined = worksheets(sheet1).range("H9:H12,H30:H42")

\
But the list included all the values between H9:H42 in my data validation list. (I do not need values from H13:H29).

 

[FryGirl]

How about by using the union method

Sub ark68()
    Dim rng_biscuits As Range
    Dim rng_flowers As Range
    Dim combined As Range
    
    Set rng_biscuits = Worksheets("Sheet1").Range("H9:H12")
    Set rng_flowers = Worksheets("Sheet1").Range("H30:H42")
    Set combined = Union(rng_biscuits, rng_flowers)
    
    combined.Value = "Hello"
End Sub

 

[Ark68]

That was too easy! (Except maybe for someone that was totally oblivious to that function!! )
Thanks so much FryGirl!

 

[FryGirl]

You are welcome. Glad it helped you, and trust me, I've received help many a time from the fine people on this site.