That's quite a bunch of pictures on a single sheet. Resources aside I don't
think the code or the "object counter" should get stuck at 65536. I don't
want to test to that extent with pictures but just added 70k shapes without
error.

However if you are locating your pictures in consecutive rows you will of
course error when you reach the bottom of the sheet.

Regards,
Peter T


"maple3" wrote in message
...
I have some VBA code which inserts pictures from files into an excel
template. The template is then used to generate an HTML file.
I run the code every day, inserting around 7500 pictures into the template
(5 for each HTML generated)
When a picure is inserted into an excel file, regardless of what the
picture
is called, excel ascribes a number to that picture i.e. Picture1,
Picture2,
Picture3 etc in that sequence.
The problem I have is that when the Picture sequence reaches 65536, the
VBA
code will no longer insert any more pictures. Oddly you can insert more
pictures manually, one by one but not using a macro.

Does anyone kno how to stop this error occurring?