Embed & Format picture into excel
Im working on a med size database in excel and want to embed a picture dependent on a cell ref selection. I need to be able to format & size the picture to fit in a selection of cells. The pictures are in a seperate folder saved as small jpeg images. The picture needs to change dependent on the selection each time.
Can anyone help with some code?