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

"Govind" wrote in message
...
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.

Fantastic Biff.Got it, Thanks a lot.

Govind.

Biff wrote:
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

"Govind" wrote in message
...

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.