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

On Mar 26, 3:36*pm, Coby wrote:
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.