Glad it helped!

Great news 😁

Glad you enjoyed it. Thanks Ricardo.

This is all down to how Excel renders the image. Therefore, I believe it is a bug. The best thing to do is use the Help -> Feedback feature to tell the Excel team about the problem.

@ExcelOffTheGrid thank you for quick response. I will contact Microsoft. My workaround for the current case was to put each line of text in separate cells, but that might not always be feasible.

You're welcome!

That's very kind of you to say. 😁

Charts and ranges are different objects. Which is why the Script can be used to get both. You'll need to do it twice - once for the range, and again for the Chart.

I think the only way to do it would be to create an oversized image initially. Then when it is resized it will look less blurry. I've not tried it, but I can't think of another way.

Figured it out. Easier than expected 😂🤣

Good stuff - they are my favourite questions… the ones that people answer themselves. 😀

Yes that would be possible. Using the techniques in this video.

Office Scripts are not saved in the workbook, they are separate files. Therefore you can reuse any script in any workbook, you don’t need to add it.

@@ExcelOffTheGrid can this be done with VBscript within PAD, or would that need to call a macro on a separate excel sheet? Currently have an excel with multiple columns and rows of images I need to extract and name. Exploring the best, easily maintainable option atm

My guess is that just referencing E5 should work. Why not just try it and see which works.

@@ExcelOffTheGrid E5:E5 works. An extension to the question, how can I loop through several images under a column to download them to onedrive or SharePoint library? Is it possible with office scripts? I have vb script which os downloding to local, am looking for office script. There is hardly any related content out there.

@@ResponsibleXI you would need to include a list of all the images in a Table. Then use Power Automate to loop each row in the Table, run the script, then save the image. At least, that is how I would do it.

@@ExcelOffTheGrid Images in excel rows are not same as text in excel rows. The column with images within excel table returns blank when looped through excel rows. That's when I figured out your video, your script pickups the image with the namee we pass, the problem is all the cells of the image column have the same image name. So flow always pickups the 1st image despite looping through all rows.