I have come up across several errors before but nothing I write will detect this one. I have Excel 2010 and the formula bar reads 374012553. When I try IsError or WorksheetFunction.IsError(xlCell.Value) I always get the same error, "Run-time error '6': Overflow".
In the case I am working with the cell needs to be cleared but nothing I write can work with this cell.
How can I detect it so I can delete it and shift everything up?
In the case I am working with the cell needs to be cleared but nothing I write can work with this cell.
How can I detect it so I can delete it and shift everything up?