Need help with inserting images from a folder

[Nirmall]

Hello everyone, have a vba code which inserts images from a folder.

Please Login or Register  to view this content.

in the above code my images load on cell C15 and cell C49 respectively,

i want the image to load on A23 and A57 respectively, can u please help as to what changes i need to make in the code?

Please note, rest everything else is working great in the code
Regards

[JEC.]

How about

Please Login or Register  to view this content.

[Nirmall]

Dont want to make any major changes in the code, may be add a line or so

Right now used (16, -3)

so that is giving me the images in the right column but not the right row, want the images to go a little down, any help on that??

[JEC.]

This code is doing the same as yours. It is only written in a simple way, which makes reading and understanding easier.
If you want to images to go down a little, then use more offset like you already mentioned.

[Nirmall]

Sorry am new to VBA code, hence the dumb question, in that if i want the images to go down, what offset values can i input??

[JEC.]

Try to use larger numbers in this line

Target.Offset(20, -3)

[Nirmall]

20 worked well,

now if i want to move it to the right??