Pasting Link problem

[Coby]

Hello.

I am having a problem using the paste method regarding pasting a link.
Any help would be greatly appreciated.
Here is a sample of my code:

' DURATION COLUMN
Worksheets("Master Schedule").Activate
Worksheets("Master Schedule").Range(Cells(M_Start_Row,
"O"), Cells(M_End_Row - 1, "O")).Select
Worksheets("Master Schedule").Range(Cells(M_Start_Row,
"O"), Cells(M_End_Row - 1, "O")).Copy
Worksheets("Operations Schedule").Activate
Worksheets("Operations Schedule").Range(Cells(Op_Start_Row
+ 2, "O"), Cells(Op_End_Row, "O")).Select
ActiveSheet.Paste link:=True

 

[Coby]

Hello.

I am having a problem using the paste method regarding pasting a link.
Any help would be greatly appreciated.
Here is a sample of my code:

' DURATION COLUMN
            Worksheets("Master Schedule").Activate
            Worksheets("Master Schedule").Range(Cells(M_Start_Row,
"O"), Cells(M_End_Row - 1, "O")).Select
            Worksheets("Master Schedule").Range(Cells(M_Start_Row,
"O"), Cells(M_End_Row - 1, "O")).Copy
            Worksheets("Operations Schedule").Activate
            Worksheets("Operations Schedule").Range(Cells(Op_Start_Row
+ 2, "O"), Cells(Op_End_Row, "O")).Select
            ActiveSheet.Paste link:=True

The Code dies at "ActiveSheet.Paste link:=True

I was wondering if perhaps the clipboard is full as my Kernel Memory
in the task manager shows
Total: 139100
Paged: 126864
Nonpaged 12216

And prior to the lines shown I have done a lot of copying and pasting.

Anyhow, I am stumped.
Thanks for your help.

Coby.