Names.RefersToRange not working on German language systems

Copper Contributor

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