Hi Greg,

I realised I accidentally added a duplicate value in one of my excel sheets, hence the "display name already exist" error.

However, I'm still getting the "invalid use of null" error.

The line in bold below is the line with error. Was just wondering if the indentation affects how the code runs?

For lngIndex = 0 To UBound(arrData1, 2)
If Not IsNull(UBound(arrData1, 2)) Then
oCC.DropdownListEntries.Add arrData1(0, lngIndex), arrData1(0, lngIndex)
End If
Next