Pasting Links

[jomili]

I'm trying to figure out the syntax for pasting links. I've got three pages where my users can update values, and those values need to be translated another (summary) page, so I'd like during the creation of the sheets to paste links from the three pages to my master page, but I'm being defeated by the syntax. Here's the latest thing I've tried (not working):

'Let's copy our pertinent data to the MFR Adjustments sheet
    Range("A2:C" & LastRow).Copy Sheets("MFR Adjustments").Range("A65000").End(xlUp).Offset(1, 0)
    Lastcol = Range("IV2").End(xlToLeft).Column
    Range(Cells(2, Lastcol), Cells(LastRow, Lastcol)).Copy
    Sheets("MFR Adjustments").Range("D65000").End(xlUp).Offset(1, 0).PasteSpecial Paste:=xllinks

Any help is greatly appreciated.

[jomili]

Okay, I guess I'll mark this as solved, though it's not, really. Instead I'm using a vlookup to get the values. I'd still like to know how to paste links for future knowledge if someone wants to provide the technique.