automatically insert picture resized by cell data name

[rag2]

hi thanks in advance i have a produc sheet where i i place all the procut information
i have in c1 Picture number and on f1 to f 5 where i want to place the picture
and my image directory is c:\images
i want to be hable to type in the picture number and it will automatically import the picture and resize it also i have every 10 rows many product entry i wish
to be hable to keep typing the picture number lets say c11 and get the picture resize in f11 to f 14 thanks i have a macro but is not doing it this way
help is apresiated asap thanks guy

 

[rag2]

please can i get some help im going crazy with this macro

 

[rag2]

why is that i never got any replays to my problem in this forum i all my previews post, i'm doing something wrong ?????????????