Switching computers - VBA problem

[Lallo]

I had a perfectly working VBA macro on my old machine, but when I switched over to a new computer, it suddenly gives an error code.

Something like this

Nr '5' Illegal procedure or argument

Things are a bit more complicated since the new machine (work computer so not installed by me) runs with Swedish language version of Office (hence the uncertainty of the exact phrasing of the error code above) , whereas my old computer runs with English ditto. Might the language of excel interfere with VBA coding? Or what is going on?

Old system:
Win XP SP3. Excel 2007 [English language]

New system:
Win 7 Professional, Excel 2007 [Swedish language]

The bit of code that causes the error is:

Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=ISNUMBER(MATCH(A1,NV,0))"

where "NV" is a named range.

Any ideas?

 

[Lallo]

I think the error code in English would be:

Runtime Error 5 - Illegal Function Call and Invalid Procedure

 

[doofusboy]

You could try:

=ISNUMBER(MATCH(A1,ThisWorkbook.Names("NV").RefersToRange,0))

 

[Lallo]

Thanks doofusboy, but sadly it didn't help. Returns same error msg.

Seeing how I'm an economist and not a programmer, it might be something obvious - some setting or other that needs tweaking.

Hmmm...

 

[Lallo]

Further information:

It turns out that the new computer has a slightly different version of VB:

New:
MS VB: 6.3 (Version 1040, VBA: 6.5.1040) (Yes, it says 6.3 in one place and 6.5.1040 in another)

Whereas the new one has

Old:
MS VB 6.5 (Version 1053, VBA: Retail 6.5.1053)