i think i have it

"'Sheet1'!Q2:Q" & lastrow

doing pretty good responding to my own posts<g
--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
this isn't really cooperating. i can't set the row source to a hidden sheet.
any way around this?

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
how can i list unique values in a combobox from a range? have about 40 rows,
1 column with about 5 unique descriptors i want to list and have the user
select one.

tried advanced filter and it shows the unique values in the range, but i
couldn't populate the combobox with the unique entries.

--


Gary