Hi
I have the following cod
Dim count1 As Intege
Worksheets("ABC").Activat
ActiveSheet.Range("AR:AR").Selec
count1 = Selection.Column.coun
For i = 1 To count
ComboBox15.AddItem CStr(Sheet1.Range("AR" + CStr(i)).Value
Nex

I want to know the last row number in column AR that contains the data (Column AR has blank cells too ) and run the loop equal number of times.
But every time I run this code, it gives an error on line "count1 = Selection.Column.count
Plz hel
Thnks