Hello,

I have a dropdown, let's say on row 4, and it's cell link is cell A4. When I
insert a row before row 4 (via macro), then the dropdown moves with all rows
one row below and is located now on row 5, as it's cell link (cell A5). The
thing is, that the cell link value does not move down with dropdown, but
remains in cell A4. Is there any workaround, because I need that the cell
link values would move with the dropdown, as it is.

I cannot duplicate your problem.
Suggest you examine your code to see if it is adding the value to the cell.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"taavo"
wrote in message
Hello,
I have a dropdown, let's say on row 4, and it's cell link is cell A4. When I
insert a row before row 4 (via macro), then the dropdown moves with all rows
one row below and is located now on row 5, as it's cell link (cell A5). The
thing is, that the cell link value does not move down with dropdown, but
remains in cell A4. Is there any workaround, because I need that the cell
link values would move with the dropdown, as it is.