Add a picture to excel and resize
Posted on 2011-09-12
I'm trying to add a picture to an excel 2007 worksheet via vba. Im using the below code to add the image to N1 but I dont know how to tweak the width and length of the image, Recording a macro in 2007 Excel just appears blank when I try to move the picture.
sub Addpicture ()
.Left = ActiveSheet.Range(“N1¿).Left
.Top = ActiveSheet.Range(“N1¿).Top