ComboBox1.ListFillRange = "'SheetXYZ'!AB100:AB200"

ListFillRange expects a string object not a range object

Dan E
"Dave Baranas" wrote in message ...
I am trying to populate a combobox's listfillrange with cells on a
different sheet

e.g.

ComboBox1.ListFillRange = Worksheets ("SheetXYZ").Range("AB100:AB200")

this gives me Run-Time error '1004"

Application-Defined or Object-Defined Error


Is there a way to do this?