Hi all

Problem:
How can I change the Cell link value?

I need to copy a combobox ex: from D15 to D16 but the problem is when I’m copying the combobox to D16, still Cell link is: $D$15. I tried by recording macro and edit the macro but it dosent help.
(I don’t want do change cell link value manually because actually I need copy 500 combobox)

Thanks in advance.