Images are in Shape objects and each Shape has a .TopLeftCell if you need to
find what cell it is "in" (at least the top left corner). Then they also
have a .Top and .Left, to set their precise location, and a .Width and
..Height, to control their size.

Cells (or any Range) also have a .Top, .Left, .Width, and .Height. So you
can use these to figure the proper values for the image or vice-versa. It
depends on whether you want to change the size of the picture to fit the cell
or the size of the cell to fit the picture.

--
- K Dales


"alenhart" wrote:

Okay, I have looked everywhere but cannot find the topic that initially
brought me he automatically centering an image over a single cell.
I have hundreds of images in a spreadsheet, each "floating" over a
specific cell, one per row, etc. What I need to do is center each image
over its cell. I have gotten past the initial stage of selecting all
the images, but I am stuck now.

Any suggestions??
thank you.