If xmx and ymx are variants, I expect that they are getting stored as
numbers.
CStr and Str convert them to strings.
--
http://www.standards.com/; See Howard Kaikow's web site.
"Brian Murphy" wrote in message
...
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