inserting multiple pictures

I am trying to insert a large number of pictures into specific cells (or rather on top of the cells) which contain the picture filename, the pictures being resized to the size of the cell.

I have searched the site and found lots of useful help particularly the code below provided by RoyUK.

I have changed this using cell (4,13) as a fixed destination intending to change these references to variables which I can then change to insert more pictures.

Unfortunately I can't get this to work. in it's current form it fails at line

Please Login or Register  to view this content.

any help on this code or alternative suggestions would be great.

Please Login or Register  to view this content.

have you tested it with break points to make sure that you not trying to reference a cell with a negative number??

To refer to a single cell you can use one of these two ways

Please Login or Register  to view this content.

then just change the referrance between the ( ).

when you use the cells() you cant put in " " so just Cells(1, 1).

to cast a range of cells you can use this

Please Login or Register  to view this content.

and that would be referencing cells from A1 to B10

lol no probs .

one thing to google that may help you is range array's. it allows you to make a collection of ranges in an array making it much easier (if thats something your work would need anyway).

if you want to check every cell in a range use this piece

Please Login or Register  to view this content.

of code

Please Login or Register  to view this content.