Mixing
Method 'Paste' of object '_Worksheet' failed when pasting graph
I would like to copy a graph from a worksheet("Copy Graph") and then paste it to another worksheet("Paste Graph") as a picture. Here is what I have:
Dim ws as worksheet
Set ws = Worksheets("Paste Graph")
Worksheets("Copy Graph").ChartObjects("Chart 1").Activate
ActiveChart.Parent.CopyPicture
ws.Paste Destination:=ws.Range("E16")
It works on my computer but when I ran it on another computer, I got the error: " Method 'Paste' of object '_Worksheet' failed"
I guess it is because of the use of "activate". Should I activate the destination range before pasting?
Also is there a way to improve the codes? I feel it's quite easy to crash.
Thank you!!!
excel vba excel-vba
asked Nov 20 '18 at 17:07
kh999459kh999459
64
add a comment |
I would like to copy a graph from a worksheet("Copy Graph") and then paste it to another worksheet("Paste Graph") as a picture. Here is what I have:
Dim ws as worksheet
Set ws = Worksheets("Paste Graph")
Worksheets("Copy Graph").ChartObjects("Chart 1").Activate
ActiveChart.Parent.CopyPicture
ws.Paste Destination:=ws.Range("E16")
It works on my computer but when I ran it on another computer, I got the error: " Method 'Paste' of object '_Worksheet' failed"
I guess it is because of the use of "activate". Should I activate the destination range before pasting?
Also is there a way to improve the codes? I feel it's quite easy to crash.
Thank you!!!
excel vba excel-vba
asked Nov 20 '18 at 17:07
kh999459kh999459
64
2
What worksheet is ws?
– GMalc
Nov 20 '18 at 17:29
@GMalc ws it's another worksheet but it's on the same workbook with "Copy Graph"
– kh999459
Nov 20 '18 at 17:32
1
Well in the context of your question,ws.Pastelooks like it would throw run-time error 91 for not beingSetto anything. Please read Minimal, Complete, and Verifiable example.
– Mathieu Guindon
Nov 20 '18 at 17:39
@MathieuGuindon I edited the question. Thank you for your comment.
– kh999459
Nov 20 '18 at 18:38
add a comment |
I would like to copy a graph from a worksheet("Copy Graph") and then paste it to another worksheet("Paste Graph") as a picture. Here is what I have:
Dim ws as worksheet
Set ws = Worksheets("Paste Graph")
Worksheets("Copy Graph").ChartObjects("Chart 1").Activate
ActiveChart.Parent.CopyPicture
ws.Paste Destination:=ws.Range("E16")
It works on my computer but when I ran it on another computer, I got the error: " Method 'Paste' of object '_Worksheet' failed"
I guess it is because of the use of "activate". Should I activate the destination range before pasting?
Also is there a way to improve the codes? I feel it's quite easy to crash.
Thank you!!!
excel vba excel-vba
asked Nov 20 '18 at 17:07
kh999459kh999459
64
I would like to copy a graph from a worksheet("Copy Graph") and then paste it to another worksheet("Paste Graph") as a picture. Here is what I have:
Dim ws as worksheet
Set ws = Worksheets("Paste Graph")
Worksheets("Copy Graph").ChartObjects("Chart 1").Activate
ActiveChart.Parent.CopyPicture
ws.Paste Destination:=ws.Range("E16")
It works on my computer but when I ran it on another computer, I got the error: " Method 'Paste' of object '_Worksheet' failed"
I guess it is because of the use of "activate". Should I activate the destination range before pasting?
Also is there a way to improve the codes? I feel it's quite easy to crash.
Thank you!!!
excel vba excel-vba
excel vba excel-vba
asked Nov 20 '18 at 17:07
kh999459kh999459
64
asked Nov 20 '18 at 17:07
kh999459kh999459
64
edited Nov 20 '18 at 18:37
kh999459
asked Nov 20 '18 at 17:07
kh999459kh999459
64
asked Nov 20 '18 at 17:07
kh999459kh999459
64
asked Nov 20 '18 at 17:07
kh999459kh999459
64
64
2
What worksheet is ws?
– GMalc
Nov 20 '18 at 17:29
@GMalc ws it's another worksheet but it's on the same workbook with "Copy Graph"
– kh999459
Nov 20 '18 at 17:32
1
Well in the context of your question,ws.Pastelooks like it would throw run-time error 91 for not beingSetto anything. Please read Minimal, Complete, and Verifiable example.
– Mathieu Guindon
Nov 20 '18 at 17:39
@MathieuGuindon I edited the question. Thank you for your comment.
– kh999459
Nov 20 '18 at 18:38
add a comment |
2
What worksheet is ws?
– GMalc
Nov 20 '18 at 17:29
@GMalc ws it's another worksheet but it's on the same workbook with "Copy Graph"
– kh999459
Nov 20 '18 at 17:32
1
Well in the context of your question,ws.Pastelooks like it would throw run-time error 91 for not beingSetto anything. Please read Minimal, Complete, and Verifiable example.
– Mathieu Guindon
Nov 20 '18 at 17:39
@MathieuGuindon I edited the question. Thank you for your comment.
– kh999459
Nov 20 '18 at 18:38
2
2
What worksheet is ws?
– GMalc
Nov 20 '18 at 17:29
What worksheet is ws?
– GMalc
Nov 20 '18 at 17:29
@GMalc ws it's another worksheet but it's on the same workbook with "Copy Graph"
– kh999459
Nov 20 '18 at 17:32
@GMalc ws it's another worksheet but it's on the same workbook with "Copy Graph"
– kh999459
Nov 20 '18 at 17:32
1
1
Well in the context of your question,
ws.Paste looks like it would throw run-time error 91 for not being Set to anything. Please read Minimal, Complete, and Verifiable example.– Mathieu Guindon
Nov 20 '18 at 17:39
Well in the context of your question,
ws.Paste looks like it would throw run-time error 91 for not being Set to anything. Please read Minimal, Complete, and Verifiable example.– Mathieu Guindon
Nov 20 '18 at 17:39
@MathieuGuindon I edited the question. Thank you for your comment.
– kh999459
Nov 20 '18 at 18:38
@MathieuGuindon I edited the question. Thank you for your comment.
– kh999459
Nov 20 '18 at 18:38
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53398044%2fmethod-paste-of-object-worksheet-failed-when-pasting-graph%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53398044%2fmethod-paste-of-object-worksheet-failed-when-pasting-graph%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
What worksheet is ws?
– GMalc
Nov 20 '18 at 17:29
@GMalc ws it's another worksheet but it's on the same workbook with "Copy Graph"
– kh999459
Nov 20 '18 at 17:32
1
Well in the context of your question,
ws.Pastelooks like it would throw run-time error 91 for not beingSetto anything. Please read Minimal, Complete, and Verifiable example.– Mathieu Guindon
Nov 20 '18 at 17:39
@MathieuGuindon I edited the question. Thank you for your comment.
– kh999459
Nov 20 '18 at 18:38