ListFillRange

  • Thread starter Thread starter Dave Baranas
  • Start date Start date
D

Dave Baranas

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?
 
ComboBox1.ListFillRange = "'SheetXYZ'!AB100:AB200"

ListFillRange expects a string object not a range object

Dan E
 
Back
Top