I have an issue I don't seem able to solve.
I have a code that always worked perfectly. Dynamically could fetch picture-url from a cell and post it in another cell.
Suddenly since 6th this month it returns 1004 error "Unable to get the insert property of the picture class"
Additional strange thing, if I run the macro on a Mac it does work without issues.
Can anybody guide me?
If PIC_Url <> "" Then
Set pic = ActiveSheet.Pictures.Insert(PIC_Url)
With pic
.ShapeRange.LockAspectRatio = msoFalse
.Height = ActiveCell.MergeArea.Height
.Width = ActiveCell.MergeArea.Width
.Top = ActiveCell.MergeArea.Top
.Left = ActiveCell.MergeArea.Left
.Placement = xlMoveAndSize
End With
End If
Bookmarks