I think I ran into a bug with vba. For whatever reason the number 13, while tests true for IsNumeric(), is not able to be evaluated with the Application.Evalutate() function
I know this seems redundant but I am pulling fractional inches IE: "61 11/16 in" removing units and spitting out 61.6875. when "13 in" came though it errors out
Some test code to demonstrate what I am talking about. running this in a test module will error out.
For the time being I will find a work around for this but I am more curious as to what's going on in the code to cause this error
replacing 13 with any other integer or fractional number works just fine. "12 2/2" even spits out 13 with no issues
Im currently on office 2016
I know this seems redundant but I am pulling fractional inches IE: "61 11/16 in" removing units and spitting out 61.6875. when "13 in" came though it errors out
Some test code to demonstrate what I am talking about. running this in a test module will error out.
For the time being I will find a work around for this but I am more curious as to what's going on in the code to cause this error
replacing 13 with any other integer or fractional number works just fine. "12 2/2" even spits out 13 with no issues
Im currently on office 2016
VBA Code:
Dim str As String
str = "13"
Debug.Print IsNumeric(str)
Debug.Print Application.Evaluate(str)