Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use Cell Link in Macro?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to link a cell in the macro | Excel Discussion (Misc queries) | |||
Link cell contents to a Macro? | Excel Programming | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
Web Query: Obtaining source link from a cell in a macro | Excel Programming | |||
Link a macro to a cell value | Excel Programming |