View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Barbe David Barbe is offline
external usenet poster
 
Posts: 1
Default autoincrementing dde link

I have a large number of dde link address that I am inputting which need the
address to increment sequentially. I can't get Excel to increment the
address. And, I don't want to type them all in. I found if I remove the =
mark at the beginning of the dde link, Excel will increment the address when
I drag the cells. But, then I have to manually go back and replace the =
mark. I have about 3000 cells to enter on multiple pages! I need a faster
way!