Incompatible type, erreur N°13

[Gogia]

Good evening,
I tried twice to execute the following macro:

Please Login or Register  to view this content.

This macro have been done by somebody else. I understand NOTHING in VBA.
This code has to open 21 files - AERES.xls, BD_equipe_1.xlsm,..., BD_equipe_20.xlsm and som the data.
However, I got each time a message "incompatibilé de type . Erreur N°13" (in French) and this code stop to run on the file BD_equipe_2.xlsm.
When I tried to open the debugger, the violet line was always indicated by yellow font.
May somebody advise me what should I do?
Thank you in advance!

[6StringJazzer]

Difficult to say without seeing the file. Look in the file BD_equipe_20.xlsm and see what data is in the ranges C4:F35,C37:F38,K4:N35,K37:N38. If any of those cells contain data that is not a number, you will get Error 13.

If it is valid for those cells to have data that is not numbers you can modify the code by adding the lines in red:

Please Login or Register  to view this content.

[Gogia]

Good evening 6StringJazzer,
Thank you for your comment. Actually, this macro, written one year ago, worked properly. I have no idea what had happened and why suddenly it stopped to work.
All ranges (C4:F35,C37:F38,K4:N35,K37:N38) contain a summarized data, and the macro above summarizes all previously already summarized date.
If I use your recommendation, does it mean than "problematic" data will be skipped?
Does exist any possibility to find such a problematic cell or range using the VBA code?
Thanks again

[6StringJazzer]

If I use your recommendation, does it mean than "problematic" data will be skipped?

Yes, it will be ignored.

Does exist any possibility to find such a problematic cell or range using the VBA code?

To diagnose, you could try this code in the same place:

Please Login or Register  to view this content.