Solved: Delete gaps in a combobox

[Helpmepls]

Hi, I have a combobox on a userform which appears with gaps in the dropdown list - is there a way I can get rid of the gaps?
The code I have to get the dropdown list is:



Me.ComboBox2.List = Worksheets("QuestionSet2").Range("a1:a25").Value


Anyone got any ideas? Thanks

[MacroShadow]

Not sure why you marked the thread as solved... In any case this is an Access forum and your question is an Excel question.

[Helpmepls]

Thanks MacroShadow. I did realise I'd posted to the wrong forum, but didn't seem to be able to delete the post, so as an alternative I marked it solved, so that people didn't waste their time reading it.