combo box???

[spinkung]

hi yet again,

***EDIT

sorry, managed to sort my last problem but it has resulted in another.

I have got the range (column A) into my list box with the follwing code....



Private Sub UserForm_Initialize()

Me.listRAN2.RowSource = "'2006 Done'!a:a"

End Sub



....but i now have the problem that it list all the blank cells in the row as well as the ones with value meaning my combo box is mostly made up of blank rows.

anyone know how to set it so that it stop adding when it gets to the frst blank cell??

thanks.