What am I doing wrong? I am trying to feed a combobox in my spreadsheet which reads data from a column in another sheet and puts it into a recordset. When I try to read from the recordset I get the error "invalid use of Null" and my recordset record count tells me that there are 21 records in my recordset.
Myrecordset.Open "Select Distinct [Business] from [TCodes$D1:D1000]", Myconnection, adOpenStatic
Do While Not Myrecordset.EOF
.AddItem Myrecordset![Business] ''''''''''''''IT FAILS HERE