You could use a dynamic range. Debra Dalgleish has some notes at:
http://www.contextures.com/xlNames01.html#Dynamic

Or maybe determine the range when you need it:

dim myRng as range
with worksheets("Sheet1")
set myrng = .range("a1", .cells(.rows.count,"A").end(xlup))
end with



Wazooli wrote:

How do I find out how many entries I have in a column, when the column length
is changing all the time? I would like to populate a combobox with entries
in a column, but I am constantly adding to the column.

wazooli

--

Dave Peterson