Combo Box Copy Issue
 

I am trying to copy a combo box down 60 rows but each combo box has to
have a different cell link. Excel seems to default to having absolute
cell/row values but even if I remove the $ the cell link stays
absolute. Can anything be done to get around this problem? Thanks.


--
chris_h_465
------------------------------------------------------------------------
chris_h_465's Profile: http://www.excelforum.com/member.php...o&userid=28233
View this thread: http://www.excelforum.com/showthread...hreadid=477828

Combo Box Copy Issue
 

Use code to place the comboboxes and set the cell link.

the macro recorder should get you started.

--
Regards,
Tom Ogilvy


"chris_h_465"
wrote in message
...

I am trying to copy a combo box down 60 rows but each combo box has to
have a different cell link. Excel seems to default to having absolute
cell/row values but even if I remove the $ the cell link stays
absolute. Can anything be done to get around this problem? Thanks.


--
chris_h_465
------------------------------------------------------------------------
chris_h_465's Profile:
http://www.excelforum.com/member.php...o&userid=28233
View this thread: http://www.excelforum.com/showthread...hreadid=477828