Also posted in the public.excel group discussion but also bringing it
here cuz i think it will ultimately require macro...

I have a combo box (not activex) that pulls it's values from a column
that varies in length. Currently I'm using the entire row (A:A) for
the input range. As you can guess, this results in MAAANY blank
entries in the box. Is there a formula or some other way so that the
combo box will stop at the end of my range of data without writing a
macro to load it that way?

It happens that Matthew Dyer formulated :
Also posted in the public.excel group discussion but also bringing it
here cuz i think it will ultimately require macro...

I have a combo box (not activex) that pulls it's values from a column
that varies in length. Currently I'm using the entire row (A:A) for
the input range. As you can guess, this results in MAAANY blank
entries in the box. Is there a formula or some other way so that the
combo box will stop at the end of my range of data without writing a
macro to load it that way?

You could make the list a dynamic range that automatically sizes itself
to the number of rows that contain data.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Check that other post, too.

On 11/23/2010 18:02, Matthew Dyer wrote:
Also posted in the public.excel group discussion but also bringing it
here cuz i think it will ultimately require macro...

I have a combo box (not activex) that pulls it's values from a column
that varies in length. Currently I'm using the entire row (A:A) for
the input range. As you can guess, this results in MAAANY blank
entries in the box. Is there a formula or some other way so that the
combo box will stop at the end of my range of data without writing a
macro to load it that way?

--
Dave Peterson