sombrenote
06-05-2009, 07:29 PM
I have columns of combo boxes. About a 12 high set, placed in each box from E3:E15. If I copy and paste those boxes, into another spread it works great, except the Cell Link does not follow.
Therefor the Combo Box in E3 will have the same Cell Link of the first box that the spread is pasted into.
I want to know how to get the Cell link to move with the copy pasted box just like it might for any formula.
I want the cell link to always be to the right of the combo box when copied and pasted.
I can not find ANY macro code which ever bring in data about WHERE the combo box is located on the spread sheet, just where you want the cell link to go.
Can anyone help?
Therefor the Combo Box in E3 will have the same Cell Link of the first box that the spread is pasted into.
I want to know how to get the Cell link to move with the copy pasted box just like it might for any formula.
I want the cell link to always be to the right of the combo box when copied and pasted.
I can not find ANY macro code which ever bring in data about WHERE the combo box is located on the spread sheet, just where you want the cell link to go.
Can anyone help?