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