View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default dropdown cell link changes when inserting a row

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.