View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Aikistan Aikistan is offline
external usenet poster
 
Posts: 6
Default VBA code for pasting links -- modifying RDB code for summary workbook

On Friday, March 29, 2013 11:16:09 AM UTC-4, Claus Busch wrote:
Untested: Set destRange = BaseWks.Range("B" & rnum) SourceRange.Copy destRange.Paste Link:=True

Claus,

Thank you for your reply. Unfortunately, the Paste Link line generates error 438. I seems like it *should* work. :(

Thanks,

Stan