Forum Discussion
InsertPictureInCell in VBA gets run-time error occasionally
Hi, I'm working on a VBA macro that Insert Picture based on cell values, the code goes like this: Range("K" & i).Select Selection.InsertPictureInCell ("D:\Folder A\" & Cells(i, 1).Value & "\" & Cel...
I tried to solve same probled and here is what i found in my case:
My worksheet, where I tried to used method InsertPictureInCell, had the previosuly pasted Picture (but manually). As soon as I removed that first picture - the problem is gone.
Then i'll return the first image to the Sheet and the problem arised again.
Don't know the logic but it works for me.