Posts by mrxinx

    Thanks RoyUK and Rory for your time.


    Yes, I got the understanding of using code tags and will use the same for my future posts.


    Yes, I posted this question in multiple forums and am reading all emails for responses received and will mark it done in all those forums.


    I got my query resolved at another board / forum and hence am updating it here as well.



    Below code by Yongle of forum MrExcel.com worked for me


    Link: Using VBA to insert a picture into a cell


    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    Dear All,



    Am calling a function from a sub by passing a string (picture path) and a range variable (Cell address).



    The function then inserts the picture and pasts it over range



    Issue: The function gives 1004 error on <range>.pastespecial command but not every time. and pressing F5 in debug mode make it run again till next error.



    Kindly guide if there is some coding error or Logical error



    Application:


    In B Column, there are some image path. say from B2 to B6.


    select B1 to make it active cell and call macro which will loop till B6.


    Pictures will be pasted on Column A for each respective row.



    ----------------------------------------------------------------------