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
.
excel vba image copy-paste
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
.
excel vba image copy-paste
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
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
.
excel vba image copy-paste
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
excel vba image copy-paste
edited Nov 8 at 13:35
ashleedawg
12.4k41848
12.4k41848
asked Nov 8 at 13:18
Paulo V. Nunes
1
1
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
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
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
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
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
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53208577%2fcopying-a-cell-with-a-picture-inside-and-pasting-in-another-sheet%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
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