Doug,
Just precede the range by the sheet name as you would in a worksheet
formula,
DRRecipient.ListFillRange = "'sheet name'!A1:A20"
--
HTH
Bob Phillips
"Chaplain Doug" wrote in message
...
Excel 2003. How do I programatically set the ListFillRange of a combobox
control to a range of cells in another sheet in the same workbook?
DRRecipient.ListFillRange = ?
The other sheet name is "Setup" and the range I want in "Setup" is
"AA1:AB365" Thanks.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org