I have the following code:

With Me.ComboBox1.TopLeftCell
..Offset(0, 5).Resize(, 4) = _
Array("NIN", "NOUT", "ZALT", "ZDTAMB")
End With

How do i tell the program that instead of me inputing the "NIN, "NOUT",
"ZALT" values myself in the Array command to simply have an something like:

Array("Sheet2!C2:C5)
The reason I want this is because I have a very long list I would other wise
need to input in the Array Command.