Resize & Placing Image Error 400

[Jhon Mustofa]

hi all...

why this code below showing error 400, i just modify the range but still error
this code :

Please Login or Register  to view this content.

here the new file :

how to fixed it?

a cross post from :
https://www.excelforum.com/excel-pro...-in-excel.html

any one would help me , much appreciated...

john m

[mjr veverka]

1. maybe it explain something, maybe not
https://www.add-ins.com/support/micr...-error-400.htm

2. You should not use word 'index' because 'Index' is a reserved word (vba property, number for an object in the collection, e.g. for Window, Worksheet, ListColumn, ListRow, PivotFormula, etc.)

3. Try alternative constructions:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

You may have other objects from the same collection of 'Shapes' in your worksheet - pictures belong to this collection, so you should check their type:

Please Login or Register  to view this content.

4. Use 'Set Pic = Nothing' at the end of assigning object variables

[Jhon Mustofa]

1. maybe it explain something, maybe not
https://www.add-ins.com/support/micr...-error-400.htm

2. You should not use word 'index' because 'Index' is a reserved word (vba property, number for an object in the collection, e.g. for Window, Worksheet, ListColumn, ListRow, PivotFormula, etc.)

3. Try alternative constructions:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

You may have other objects from the same collection of 'Shapes' in your worksheet - pictures belong to this collection, so you should check their type:

Please Login or Register  to view this content.

4. Use 'Set Pic = Nothing' at the end of assigning object variables

Thank porucha..after tested your code not fully work..
i mean only 2 pictures can move and placing in the right place (in frame/box available) and 2 picture the other not move...
i want all picture can move, resize, and "in" that frame/box...
please, would you help me...

here my sample that my expected...

[mjr veverka]

at my place it's working - see attachments (it's mp4 files, working with e.g. mpc-hc)
it may be something with a pictures format at you ... maybe ...

[Jhon Mustofa]

at my place it's working - see attachments (it's mp4 files, working with e.g. mpc-hc)
it may be something with a pictures format at you ... maybe ...

hi porucha..i was trying again but still error "the parameter syntax is incorrect
my picture is good nothing problem...
please, check in my new file...

[mjr veverka]

Attach a screenshot from manually (F8 key in vba editor) testing of macro code with error message, I will see in which line it occured.