Putting a Range into an Array

[business_analyst]

Hello All,

So I would like to put a certain range into an array, which would seem easy enough using a variant, however, I am running into a few issues. First off, the range I would like to use may change in length and also has a header that I don't want included in the array. I know that utilizing end(xlUp) I can find the last cell in the column, but how would I use that to actually select a range?

For a full picture, there is a worksheet with a list of ID's located in column A. I would like to take A2 through the end of the list and send that to an array.

 

[Ruddles]

Try:-

Dim iLastRow As Long
Dim vStore() As Variant
iLastRow = Cells(Rows.Count, 1).End(xlUp).Row
vStore = Application.Transpose(Range("A2:A" & iLastRow))

 

[business_analyst]

Thanks Ruddles, used that and it worked perfectly. I didn't think that you can split up a Range with variables. I'm sure that will come in handy with future coding as well . Thanks again.