run time error 6 - overflow

[Uri]

My macro reads article numbers from 1 column, searches the image in a central folder and places the image in a separate column. When the number of articles exceeds 476 I get a run time 6 error. It occurs within the main loop and is probably not due to the specific command where it stops. Any tip is most welcome.

 

[NARAYANK991]

Hi ,

If you can post the complete code for the macro which gives this error , you can get an answer faster.

Narayan

 

[Uri]

Thanks. I found the problem, It was an integer that got a value > 32767