N
Nicke
Hi,
I use intersect to get values from an array to a sheet.
Everything works fine in Excel 97,2000 and XP. But in
Excel 2003 it fails when a number contains a comma as
decimal delimiter. Excel 2003 seems to always use period
as a decimal delimiter even if my national settings says
comma.
Example:
Dim Arr As Variant
ReDim Arr(0, 0)
Arr(0, 0) = "123,345"
Intersect(Range("A1"), Range("A1")) = Arr
This will return "123 345" in Excel 2003 and 123,345 in
all other versions.
Is this a bug?
BTW, i've checked "Use system separators" in the options
dialog.
Any tip will be appreciated
/Nicke
I use intersect to get values from an array to a sheet.
Everything works fine in Excel 97,2000 and XP. But in
Excel 2003 it fails when a number contains a comma as
decimal delimiter. Excel 2003 seems to always use period
as a decimal delimiter even if my national settings says
comma.
Example:
Dim Arr As Variant
ReDim Arr(0, 0)
Arr(0, 0) = "123,345"
Intersect(Range("A1"), Range("A1")) = Arr
This will return "123 345" in Excel 2003 and 123,345 in
all other versions.
Is this a bug?
BTW, i've checked "Use system separators" in the options
dialog.
Any tip will be appreciated
/Nicke