Forum Discussion
VLOOKUP issue with pictures
I need help with my 3 tab spreadsheet where 1 tab is the pictures, 'ALL' tab that has the whole dataset and the last tab is the final sheet that uses the VLOOKUP to bring the data over from the All ...
its a few years now, and I am still having this issue. I have a 1200 pictures in separate cells that I want to "Place in cell" so I can reference from a separate spreadsheet. I can use vlookup or IMAGE function?
Besides spending an hour or more hitting each picture to "place in cell" is there a way to "Place in cell" in once action or formula?
You can use a macro to loop through the objects in the sheet:
Sub PlaceAllPicturesInCells()
Dim s As Shape
Application.ScreenUpdating = False
'Go through all pictures in sheet and place in cells
For Each s In ActiveSheet.Shapes
s.Select
s.PlacePictureInCell
Next s
Application.ScreenUpdating = True
End SubI'm not a vba guy so this looks rudimentary but gets the job done.