Private Sub UserForm_Initialize()
Dim iRow As Integer, iRowL As Integer
iRowL = Cells(Rows.Count, 1).End(xlUp).Row
For iRow = 2 To iRowL
If Rows(iRow).Hidden = False Then
lstVisibleCells.AddItem Cells(iRow, 1).Value
End If
Next iRow
End Sub