Loop through OLEobject images on worksheet

Hello all,

I have 8 OLEobject image holders on a worksheet and want to loop through them so that I can add images to them in turn as the images will change based on the other code I am using. But I want to reference their name as a variable so that if I change the amount of them (image objects) in the future I just increase the size of the loop to account for the increase.

I've tried this but keep getting error messages

Please Login or Register  to view this content.

Any help much appreciated.

Chimpy

Here is part of some I tried but i'm not that hot at VBA and have to relearn it everytime I use as I use it so infrequently. Old age unfortunately, and a memory like a fish

Please Login or Register  to view this content.

Thanks

Does this make more sense?

Please Login or Register  to view this content.

Cheers

Thanks for the reply mate, unfortunately i'm getting the following error message:

'Unable to get the OLEObject property of the Worksheet class'

on this line

Please Login or Register  to view this content.

Does that mean it can't find the image object?

Huzzah! you're right chap, it doesn't have the period in front of "img", all sorted now. Thanks very much for the help I was pulling my grey hair out.