Pasting Link problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Coby - 26 Mar 2008 23:36 GMT

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

Reply to this Message

Coby - 26 Mar 2008 23:39 GMT

> Hello.
>
[quoted text clipped - 12 lines]
> + 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.

Reply to this Message