Names.RefersToRange not working on German language systems

%3CLINGO-SUB%20id%3D%22lingo-sub-1502734%22%20slang%3D%22en-US%22%3ENames.RefersToRange%20not%20working%20on%20German%20language%20systems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1502734%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20constructed%20some%20VBA%20which%20uses%20the%20Names.RefersToRange%20to%20overcome%20some%20limitations%20I%20encountered%20when%20using%20Names.RefersToRange.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20workbook%20has%20been%20successfully%20tested%20and%20used%20by%20those%20with%20English%20language%20system%2C%20but%20I%20have%20been%20getting%20feedback%20that%20it%20won't%20work%20for%20my%20colleagues%20in%20Germany%3B%20which%20we%20have%20narrowed%20down%20to%20the%20German%20language%20setting%20on%20their%20systems%2C%20not%20just%20the%20Office%20install%20(verified%20when%20I%20was%20able%20to%20replicate%20the%20error%20after%20a%20language%20change).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20else%20encountered%20this%3F%20If%20so%2C%20what's%20the%20workaround%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERyan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1502734%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

 

I have constructed some VBA which uses the Names.RefersToRange to overcome some limitations I encountered when using Names.RefersToRange.

 

The workbook has been successfully tested and used by those with English language system, but I have been getting feedback that it won't work for my colleagues in Germany; which we have narrowed down to the German language setting on their systems, not just the Office install (verified when I was able to replicate the error after a language change).

 

Has anyone else encountered this? If so, what's the workaround?

 

Regards,

 

Ryan

0 Replies