CB Data from column minus blanks

Hi all, prolly missing one small piece here. I want to populate my combobox with the values in (for example) C: column. If I don't define the cells with data, the CB displays a ton of blank space. Because my table data is updated and added to, trying to define it means I have to change the script from time to time. In short, how do I ask for a return of only cells in C: with a value, i.e. no blanks. A snippet is attached.

Please Login or Register  to view this content.

Hi

Maybe loop through the range and add the items that aren't blank....

Please Login or Register  to view this content.

rylo

Hi there, get a compile error: Variable not defined (ce)

Add

Please Login or Register  to view this content.

above the first use of cE

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

Ok, still not working. I need to reference the sheets where the table data resides as in my example above. Any ideas?

Hi

Please Login or Register  to view this content.

rylo

That did the trick! Thanks Rylo