Answer the question
In order to leave comments, you need to log in
How to fix Vba error 1004?
Good afternoon, I want to insert a picture into a sheet in a book, I found this code
With Worksheets(lstname).Pictures.Insert(PicPath)
With .ShapeRange
.LockAspectRatio = msoTrue
.Width = 75
.Height = 100
End With
.Left = Worksheets(lstname).Cells(5, 5).Left
.Top = Worksheets(lstname).Cells(5, 5).Top
.Placement = 1
.PrintObject = True
End With
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question