paste links - vba

[Kaps_mr2]

Hi,

I am trying to paste links between workbooks. I thought it could be done along the lines of :-

data_range.Copy
   Masterworkbook.Sheets(List_of_PCT_Codes_from_File_names(r)).Range("c1").PasteSpecial , Paste:=xlPasteColumnWidths
   Masterworkbook.Sheets(List_of_PCT_Codes_from_File_names(r)).Range("c1").PasteSpecial , Paste:=xlPastelinks
   Masterworkbook.Sheets(List_of_PCT_Codes_from_File_names(r)).Range("c1").PasteSpecial , Paste:=xlPasteFormats

however - no luck. Any suggestions ?

Thanks

Kaps