Copying & Pasting Controls

[ofthe3rdkind]

I am creating a worksheet with several hundred lines. The worksheet will feature a conbo box on each row for selecting data. When I copy and past the combo box, the "cell link" under the controls tab (format controls) shows the older linked cell -- not the new linked cell.

Do I have to go and change several hundred format controls or is there an easier way?

Thanks!

 

[Norie]

What is the combobox being used for?

Couldn't you use Data>Validation... with the List option?