I'm building some reports in Excel (2010) and DataLink (2014). When results are returned, there are many different ways how errors are reported back. "Tag not found", "Attribute not found", "No events found.".
Is there any smart way to detect if a cell has a valid result or not? E.g. how to detect if i have a valid result when retrieving an AF attribute of type String with the value "Attribute not found".
When numeric values are expected, a check for IsNumber() helps, but e.g. for strings, this falls apart.