How do I use Cell Link in Macro?
 

I am trying to create Combo Box on one worksheet to access list of names on
another worksheet and copy name and address into the first worksheet. I have
the Cell link cell on the sheet with the names. I am trying to create the
macro and use the cell link in it to access the correct name and address. I
can not figure out how to do this. Any help would be appreciated.