Hello!
i am using this code to import pictures into my worksheet. After they are imported, the pictures are cropped and then placed in cell B3 and downward (B3, B4, B5, etc.)
However, the code is running perfectly fine, but the whole process which this macro is implemented is too complicated. Now, I would like to know if someone could help me please to arrange that the macro to do the following:
1. impot the pictures (already done by macro)
2. crop the pictures (already done by macro)
3. I have a key number starting from A3 downwards (1, 2, 3, etc) and if the FILENAME of the picture (1.bmp, 2.bmp, 3.bmp) is the same as this key number, insert the picture in column B of that row.
Hope someone understands what I mean!
Thanks a lot!!!!!
A2k
Bookmarks