Hi All,

I have a userform which gets its data from a dynamic named range. The combo box is properly populated if there is more than one item in the list, but throws up a "run-time error 381: Could not set List property. Invalid property array index" if there is only one item in the list. I'm hoping there is a simple solution to this. The code I'm using for this is (in case it can be helpful):
Range("K3", Range("K" & Rows.Count).End(xlUp)).Name = "PtID"
cboRecall.List = Sheets("Summary").Range("PtID").Value
Further investigation indicated to me that the problem is that the userform is starting from a named range which "grows", starting from an index of zero. This is the source of the problem. What is the workaround?

This is cross-posted at http://www.mrexcel.com/forum/excel-q...med-range.html.