This is what I have
Sheets("name list").Select
Range("A1").Select
ActiveCell.Offset(2, 0).Range("B1:D4").Select
Selection.Copy
Sheets("Transm.").Select
Range("B10").Select
ActiveSheet.Paste
Range("B14").Select
End Sub

I think I want to insert the cell reference (E1) into the line where the 2
is. E1 is my Cell link location.


"dfrost57" wrote:

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.