Range.PlacePictureOverCells Explanation Request

Hello,

While exploring the object browser to learn more properties and methods available for use, I discovered "PlacePictureOverCells" which is a method member of Excel.Range. I don't know how to use this or even what it is supposed to do.

I assumed it would place an image over the selected range. However, whenever I created a basic sub (shown below) I just got errors. Initially I tried this with no specifications between the parenthesis, but then later tried it with a file path leading to an image. Still no success.

Can someone explain this method to me? I have found absolutely nothing online when searching for Range.PlacePictureOverCells.

Please Login or Register  to view this content.

It's not surprising you haven't found anything online as it's a very new feature. It also seems very buggy in my tests - only works at all for me if the range is A1. The image seems to need to be passed as a reference to an IPictureDisp object, which you get as the result of LoadPicture.