Tried using macro recorder to get code for camera tool, but nothing recorded. Then I did a search here and found some code, but I'm getting error on highlighted line. Am I missing a reference or something? Am using Excel2007 by the way.
ERROR: Run-time error '1004':
Unable to get the Paste property of the Pictures class
ERROR:
Run-time error '438':
Object doesn't support this property or method
If I change code to:
[/COLOR]
ERROR: Run-time error '1004':
Unable to get the Paste property of the Pictures class
Code:
Range("A1:C9").Select
Application.CutCopyMode = False
Selection.Copy
Range("M1").Select
[B][COLOR=red]ActiveSheet.Pictures.Paste(Link:=True).Select[/COLOR][/B]
ERROR:
Run-time error '438':
Object doesn't support this property or method
If I change code to:
Code:
Range("A1:C9").Select
Application.CutCopyMode = False
Selection.Copy
Range("M1").Select
[COLOR=red][B]ActiveSheet.Picture.Paste(Link:=True).Select[/B][/COLOR][COLOR=black]
Last edited: