Named range translate automaticly

[stigcorneer]

Hi, I have a workbook with a named range called "Databas" (database in Swedish).
But when a friend opened the workbook with a Excel with english language settings the range name had changed to "Database" automaticly.
This messed upp an VBA-macro.

Do anyone know why the translation was done?
How can I prevent it in the future?

 

[saboh12617]

Hello,

That sounds very strange to me. More likely it got renamed by mistake.

What is exactly this named range? A structured table? If so, you might use Worksheet.ListObjects instead of Range to access it.

 

[stigcorneer]

Hello,

That sounds very strange to me. More likely it got renamed by mistake.

What is exactly this named range? A structured table? If so, you might use Worksheet.ListObjects instead of Range to access it.

No it's just a single cell.

 

[Alex Blakenburg]

That happened to come up on LinkedIn a few days ago.
Database is effectively a reserved word used to drive a built in user form.

Patryk Samborski on LinkedIn: The Hidden Meaning Behind This Excel Range Name! Most People Don't Know… | 13 comments

The Hidden Meaning Behind This Excel Range Name! Most People Don't Know It: It's.. "𝗱𝗮𝘁𝗮𝗯𝗮𝘀𝗲". Ever heard of Data Form? It's a built-in user form… | 13 comments on LinkedIn

www.linkedin.com

 

[stigcorneer]

OMG!
Perhaps the Excelteam should not keep that a secret...

Thank you

 

[Alex Blakenburg]

You're welcome. Glad we could help.