I have named ranges with these values in different parts of the workbook:
Named_range_1:
1
2
3
Named_range_2:
4
5
6
Named_range_3:
7
8
9
Im trying to get all of these named ranges into one array like this:
array_1:
1
2
3
4
5
6
7
8
9
I tried to write the code but it will only accept one named range at a time:
Sub test133()
Dim array_1 As Variant
array_1 = Range("Named_range_1").Value
Dim i As Long
For i = LBound(array_1, 1) To UBound(array_1, 1)
Debug.Print array_1(i, 1)
Next i
End Sub
How can I load more named ranges into the array?
Thankful for any help!
Bookmarks