How to Add Data To An Array When Column Has Blank Cells

[Brad24]

Hi, I have names in a column but some cells are empty. I want to grab the first 32 names and put them into an array, but how would I skip over the empty cells? THis is using vba.

 

[jim may]

If you are looping through the range, you just need to qualify each cell before performing the work on it.

If MyCell <> "" then '<<< This qualifys the cell as being a cell which IS NOT Blank

' your code to perform

End if

 

[Brad24]

ahhh, Ok, I will try that. Thanks!

 

[Brad24]

I have another question: If my data is in rows 1 to 1500, how do I pick off the data and put it in the array sequentially from 0 to 31?
Currently, I am back to my original problem. If there is data on line 400 and 402, then 401 is blank, and the array index will be empty

I have

For k = 1 To 1500
    If Sheets("Segment Staging").Cells(k, 3).Value <> "" Then
    'Copy the name into the Array
    MyArray() = Sheets("Segment Staging").Cells(k, 3).Value
Next k