Copying a cell with a picture inside and pasting in another sheet

up vote
0
down vote

favorite

I'm having an issue trying to paste a copied cell that has a picture inside. I'll put the code here so you guys can try to understand the situation. Everything in the code is working fine but this.

Thank you very much.

Do While shtPic.Cells(k, 1) <> Empty

    If shtPic.Cells(k, 1) = shtProforma.Cells(j, 2) Then

        shtPic.Cells(k, 3).Copy

        shtProforma.Cells(j, 3).PasteSpecial xlPasteAll

        Exit Do

    End If

    k = k + 1

Loop

The copying part is fine. It copies from the shtPic but it don't paste at shtProforma.

edited Nov 8 at 13:35

ashleedawg

12.4k41848

asked Nov 8 at 13:18

Paulo V. Nunes

Activate your second sheet first, select destination cell and then paste. Make sure the picture doesn't exceed the cell's borders!
– JvdV
Nov 8 at 13:27

Start the macro recorder and then perform the task manually. Then you can inspect and/or change the generated code as required. See: Recording a Macro to Generate Code and Revising Recorded Visual Basic Macros.
– ashleedawg
Nov 8 at 13:33

Which Error-Code do you get? Are shtPic and shtProforma worksheets? Can you show the whole code?
– Igelaty
Nov 8 at 17:17

I don't get any error. It just don't paste the cell with the picture inside. I've run some tests with the same cell but with a word inside and it copies and paste normally. And yes, they are worksheets.
– Paulo V. Nunes
Nov 12 at 17:45

add a comment |

up vote
0
down vote

favorite

I'm having an issue trying to paste a copied cell that has a picture inside. I'll put the code here so you guys can try to understand the situation. Everything in the code is working fine but this.

Thank you very much.

Do While shtPic.Cells(k, 1) <> Empty

    If shtPic.Cells(k, 1) = shtProforma.Cells(j, 2) Then

        shtPic.Cells(k, 3).Copy

        shtProforma.Cells(j, 3).PasteSpecial xlPasteAll

        Exit Do

    End If

    k = k + 1

Loop

The copying part is fine. It copies from the shtPic but it don't paste at shtProforma.

edited Nov 8 at 13:35

ashleedawg

12.4k41848

asked Nov 8 at 13:18

Paulo V. Nunes

Activate your second sheet first, select destination cell and then paste. Make sure the picture doesn't exceed the cell's borders!
– JvdV
Nov 8 at 13:27

Start the macro recorder and then perform the task manually. Then you can inspect and/or change the generated code as required. See: Recording a Macro to Generate Code and Revising Recorded Visual Basic Macros.
– ashleedawg
Nov 8 at 13:33

Which Error-Code do you get? Are shtPic and shtProforma worksheets? Can you show the whole code?
– Igelaty
Nov 8 at 17:17

I don't get any error. It just don't paste the cell with the picture inside. I've run some tests with the same cell but with a word inside and it copies and paste normally. And yes, they are worksheets.
– Paulo V. Nunes
Nov 12 at 17:45

add a comment |

up vote
0
down vote

favorite

I'm having an issue trying to paste a copied cell that has a picture inside. I'll put the code here so you guys can try to understand the situation. Everything in the code is working fine but this.

Thank you very much.

Do While shtPic.Cells(k, 1) <> Empty

    If shtPic.Cells(k, 1) = shtProforma.Cells(j, 2) Then

        shtPic.Cells(k, 3).Copy

        shtProforma.Cells(j, 3).PasteSpecial xlPasteAll

        Exit Do

    End If

    k = k + 1

Loop

The copying part is fine. It copies from the shtPic but it don't paste at shtProforma.

edited Nov 8 at 13:35

ashleedawg

12.4k41848

asked Nov 8 at 13:18

Paulo V. Nunes

I'm having an issue trying to paste a copied cell that has a picture inside. I'll put the code here so you guys can try to understand the situation. Everything in the code is working fine but this.

Thank you very much.

Do While shtPic.Cells(k, 1) <> Empty

    If shtPic.Cells(k, 1) = shtProforma.Cells(j, 2) Then

        shtPic.Cells(k, 3).Copy

        shtProforma.Cells(j, 3).PasteSpecial xlPasteAll

        Exit Do

    End If

    k = k + 1

Loop

The copying part is fine. It copies from the shtPic but it don't paste at shtProforma.

excel vba image copy-paste

edited Nov 8 at 13:35

ashleedawg

12.4k41848

asked Nov 8 at 13:18

Paulo V. Nunes

edited Nov 8 at 13:35

ashleedawg

12.4k41848

asked Nov 8 at 13:18

Paulo V. Nunes

edited Nov 8 at 13:35

ashleedawg

12.4k41848

edited Nov 8 at 13:35

ashleedawg

12.4k41848

edited Nov 8 at 13:35

ashleedawg

12.4k41848

asked Nov 8 at 13:18

Paulo V. Nunes

asked Nov 8 at 13:18

Paulo V. Nunes

asked Nov 8 at 13:18

Paulo V. Nunes

Activate your second sheet first, select destination cell and then paste. Make sure the picture doesn't exceed the cell's borders!
– JvdV
Nov 8 at 13:27

Start the macro recorder and then perform the task manually. Then you can inspect and/or change the generated code as required. See: Recording a Macro to Generate Code and Revising Recorded Visual Basic Macros.
– ashleedawg
Nov 8 at 13:33

Which Error-Code do you get? Are shtPic and shtProforma worksheets? Can you show the whole code?
– Igelaty
Nov 8 at 17:17

I don't get any error. It just don't paste the cell with the picture inside. I've run some tests with the same cell but with a word inside and it copies and paste normally. And yes, they are worksheets.
– Paulo V. Nunes
Nov 12 at 17:45

add a comment |

Activate your second sheet first, select destination cell and then paste. Make sure the picture doesn't exceed the cell's borders!
– JvdV
Nov 8 at 13:27

Start the macro recorder and then perform the task manually. Then you can inspect and/or change the generated code as required. See: Recording a Macro to Generate Code and Revising Recorded Visual Basic Macros.
– ashleedawg
Nov 8 at 13:33

Which Error-Code do you get? Are shtPic and shtProforma worksheets? Can you show the whole code?
– Igelaty
Nov 8 at 17:17

I don't get any error. It just don't paste the cell with the picture inside. I've run some tests with the same cell but with a word inside and it copies and paste normally. And yes, they are worksheets.
– Paulo V. Nunes
Nov 12 at 17:45

Activate your second sheet first, select destination cell and then paste. Make sure the picture doesn't exceed the cell's borders!
– JvdV
Nov 8 at 13:27

Start the macro recorder and then perform the task manually. Then you can inspect and/or change the generated code as required. See: Recording a Macro to Generate Code and Revising Recorded Visual Basic Macros.
– ashleedawg
Nov 8 at 13:33

Which Error-Code do you get? Are shtPic and shtProforma worksheets? Can you show the whole code?
– Igelaty
Nov 8 at 17:17

I don't get any error. It just don't paste the cell with the picture inside. I've run some tests with the same cell but with a word inside and it copies and paste normally. And yes, they are worksheets.
– Paulo V. Nunes
Nov 12 at 17:45

add a comment |

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',
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
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53208577%2fcopying-a-cell-with-a-picture-inside-and-pasting-in-another-sheet%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

active

oldest

votes

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Agfdhyk