Another VBA bug
This is xl2002. VBA says that IsNumeric("3,45") is okay. There is a simple
workaround. WorksheetFunction.IsNumber("3,45") correctly notes that it is
not a number.
Don't you just like the consistency of the function naming here?
Don <www.donwiss.com (e-mail link at home page bottom).
|