Hi All,

Is there a way to find out strings in an array and replace them with zeros?

I have an array of elements which I am supposed to sum and compare/subtract with a particular cell value but there may be strings in that array and when I sum its throwing me an error 'Type Mismatch'.

Appreciate your suggestions.


Regards,
xlbee