Image alignment

[ExcelRoy]

Hi all,

Not sure if this is possible but...

I have various images on a workbook, equally spaced out in rows, but they are currently aligned to the left of column L or M

is there a way that if i highlight Columns L & M i can align them to the right of column M with 1 spacing

Maybe this is a job for code i'm not sure

Many thanks for any help!

 

[EXCEL MAX]

Hello ExcelRoy,
what is the real problem?
You can select all images, align them to the left, drag and drop them to the right.
Do you need to do that with VBA or is some specific problem?

 

[ExcelRoy]

hi EXCEL MAX,

i have 764 images in total, so was hoping for an easier solution

Thanks

 

[EXCEL MAX]

Can you select one image, then select all with Ctrl+A and then make align?