Forum Discussion
Dtripple40
Sep 22, 2021Copper Contributor
Excel will not pull picture
So I am trying to reference a cell with a picture in it that way it pull the picture into another cell. I have watched about 6 videos on how to name the cell, then place the picture in the cell ...
Juliano-Petrukio
Sep 23, 2021Bronze Contributor
I just added a Named Range called SelectedPicture using the formula
=INDIRECT(Sheet2!$G$2)
Find attached.
Dtripple40
Sep 23, 2021Copper Contributor
Thank you!!
Im running into having to try and pull a picture with a name that needs a space and you can not have names with spaces for cells. So I need to figure out how to delete spaces automatically to pull pictures.
Thank You for your help.
Im running into having to try and pull a picture with a name that needs a space and you can not have names with spaces for cells. So I need to figure out how to delete spaces automatically to pull pictures.
Thank You for your help.
- Juliano-PetrukioSep 23, 2021Bronze Contributor
What about you eplace the spaces by some character such Underscore ( _ ) or dash (-) ?
By the way, if my proposal worked fine, hit the like button and flag it as solved.