Hello,
I am trying to search a column say M (From M2:M2999) in an excel file and see if I have division by zero errors (#DIV/0!) , and I would like to replace the text with text string '0'.
Can someone please show me the IIF code for it? Or some other way to replace the text programmatic'ally in VBA.
Thanks