What I use is a simple excel function to count the populated cells. Use
something like:
=100-COUNTBLANK(A1:A101)
adjust that to whatever cell range you are using and then reference that
cell in the for loop when populating the combobox.


"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