chem101
10-18-2010, 10:41 AM
Hello Everyone,
I'm having trouble copy a picture from one worksheet to another. I'm able to import the .jpeg using code without a a problem - I just can't seem to copy it to another worksheet based on two conditions. Here's what I've been trying with no positive results:
Sub CopyWHMSTRPic()
Dim ws As Worksheet
Set ws = ActiveSheet
If Range("InputboxStyle").Value = "ABC" And Range("InputJoint").Value = "Textured" Then
ws.Range("i33:aa43").CopyPicture
Worksheet("WH Master").Range("aa24").Activate
Worksheeets("WH Master").Paste
End If
End Sub
Can you help me?
Any help you can provide will be greatly appreciated.
Thank you!
I'm having trouble copy a picture from one worksheet to another. I'm able to import the .jpeg using code without a a problem - I just can't seem to copy it to another worksheet based on two conditions. Here's what I've been trying with no positive results:
Sub CopyWHMSTRPic()
Dim ws As Worksheet
Set ws = ActiveSheet
If Range("InputboxStyle").Value = "ABC" And Range("InputJoint").Value = "Textured" Then
ws.Range("i33:aa43").CopyPicture
Worksheet("WH Master").Range("aa24").Activate
Worksheeets("WH Master").Paste
End If
End Sub
Can you help me?
Any help you can provide will be greatly appreciated.
Thank you!