I've tried that it says ActiveSheet.Paste Link:=True, tried it and i get Run time error 1004 paste method of worksheet class failed when I try using it.