PDA

View Full Version : Solved: Copy a Picture



chem101
10-15-2010, 11:59 AM
Hello Everyone,

I'm trying to copy a picture using VBA code. The code that I'm using is:

Sub CopyPic()
Range("c22:s34").CopyPicture Range("y22")

The error message that I'm getting is:
'CopyPicture method of Range class failed'

Any suggestions on how I can fix this??

Any help you can provide will be greatly appreciated.

Thank you!!

CBrine
10-15-2010, 12:30 PM
Give this code a try


Dim ws As Worksheet
Set ws = ActiveSheet
ws.Range("C22:S34").CopyPicture
ws.Range("C3").Activate
ActiveSheet.Paste



HTH
Cal

chem101
10-15-2010, 12:33 PM
Thanks for your assistance.