On Error is needed for this piece of code 'cause of the way beyond used a VBA Collection.
I was stating about On Error not for the Collection - as you can see within my code my Collection way does not need it neither -
but to sum the data in case of a text cell instead of a numeric value …

Thanks for the rep' !