I have a long spreadsheet (Excel 2010) imported from word as a copy and paste (i.e. the original table was in word, I opened word doc, selected all, and pated into excel). There were about 20 original word docs that had to be comined into the one excel sheet.

I have 8 columns, 7 of which are straightforward text, 1 (column D) contains a picture. These vary in size and shape (some square, some long rectangle, some tall rectangle) and were taken from a 3rd source into the sheet.

I have checked in "size and properite/ size, and all pics are set to "move and size with cell".



The question- I need to set all pictures to be locked in size, so they do not scale with cells, and to be able to set the row height to be slightly greater than the pic. I searched for VBA macros that wold help, so far I can only foind ones that assist with importing pics.

Any help would be mch appreciated, if you need more details, let me know.

thanks

Hi

I don't see a problem.
Copy part of it and insert to a spreadsheet. Record a macro while performing the required steps manually on one picture. That gives you an idea what the code looks like. Afterwards you can adjust in a loop all pictures/cells the same way.

If you need more help, please upload a small example of the spredsheet what it looks like after copy.