Merging columns, excluding columns, and calculating columns by division over another

Originally Posted by Marc L

No problemo !

An easy workaround : If Not IsNumeric …

My dear Marc (with "c", Jajaja ): The IsNumeric function (just like IsDate with dates) is not foolproof with numbers either. For example, the following two cases cannot both be TRUE for the same configuration:

PHP Code: 

Sub Test1()
MsgBox "a) 1.234,56 : " & IsNumeric("1.234,56") & vbLf & vbLf & _
  "b) 1,234.56 : " & IsNumeric("1,234.56")
End Sub 


But Excel detects the difference.