software

Hi,

I have created about 10 combo boxes with the same input range. But when
i want to expand the input range, i need to go to each of the combo box
and change its input range individually. Is there a better way of doing
this than changing this individually?

Regards
Govind.

Hi!

Just use a dynamic named range as the source. I've seen you post replies to
questions so I'm assuming you know how to do that.

Biff

quot;Govindquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I have created about 10 combo boxes with the same input range. But when i
gt; want to expand the input range, i need to go to each of the combo box and
gt; change its input range individually. Is there a better way of doing this
gt; than changing this individually?
gt;
gt; Regards
gt; Govind.
Fantastic Biff.Got it, Thanks a lot.

Govind.

Biff wrote:
gt; Hi!
gt;
gt; Just use a dynamic named range as the source. I've seen you post replies to
gt; questions so I'm assuming you know how to do that.
gt;
gt; Biff
gt;
gt; quot;Govindquot; gt; wrote in message
gt; ...
gt;
gt;gt;Hi,
gt;gt;
gt;gt;I have created about 10 combo boxes with the same input range. But when i
gt;gt;want to expand the input range, i need to go to each of the combo box and
gt;gt;change its input range individually. Is there a better way of doing this
gt;gt;than changing this individually?
gt;gt;
gt;gt;Regards
gt;gt;Govind.
gt;
gt;
gt;