Danish & German Goto SpecialCells Error

[Bill]

To All

When using the following code it works fine when in UK locale. But, when I
change the locale to Danish or German I get the error thereafter. Any ideas
or a way around this problem

rngFormula = rng.SpecialCells(Excel.XlCellType.xlCellTypeFormulas, 23)

ERROR:
System.Runtime.InteropServices.COMException (0x800A03EC): SpecialCells
method of Range class failed
at System.RuntimeType.ForwardCallToInvokeMember(String memberName,
BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData&
msgData)
at Microsoft.Office.Interop.Excel.Range.SpecialCells(XlCellType Type,
Object Value)

Thanks in advance.

 

[Bill]

Please ignore. Resolved.