international problem, decimal separator and chart series
Hello Excel NewsGroup,
I've run across a strange behavior in excel (2000 and XP) when running on a system with a non-english installation. When running the following code, a chart series is the current Selection, and I am trying to change its definition to display specific hardwired points.
xmn = 0
xmx = 1.1
ymn = 0
ymx = 1.1
With Selection
.XValues = CStr(xmn) & "," & Str(xmx)
.Values = Str(ymn) & "," & Str(ymx)
End With
In the above code, I found that the CStr and Str function calls are required to get the correct result. Does anyone know why CStr seems to be required?
Thanks,
Brian Murphy
Austin, Texas
|