Replace text in cell with picture (or insert picture into same cell)

[plainhavoc]

Thank you so much, this works like a charm!

For educational purposes, how does the "Call ClearPics(ws1)" work where it does?

I initially thought with it ordered in that manner, it would clear the pictures as soon as it cycled through each one in the loop. I guess my understanding of the logic is far too insufficient at present.

Again, thank you so much! Now my wife won't have to spend countless hours at home changing these for her retirement home employer.

[mdmackillop]

On the assumption the layout may change, it seemed best to remove any existing pictures from the range prior to adding new ones. You could make this a separate procedure.

[plainhavoc]

That makes sense now. Again, thank you so much! Her workload has gone from spending around 3 hours doing this, down to around 10 minutes. Now she and I can actually spend some time together!