'What setting is causing Excel VBA to change the named Range.Style "Percent" to "Per cent"?
I have an xlsm workbook that gives a "Subscript out of range" error in response to ThisWorkbook.Styles("Percent").Value on one system but not on another. On the system that throws the error the style named "Percent" seems to have been replaced by one called "Per cent". I suspect this has its origins in language settings differing on the two computers. The working system is set to English (UK) throughout but I'm unable to establish which setting or combination of settings would result in Excel renaming the style internally without warning. Changing some of the settings to English (United States) seems to be non-trivial and I'm scared to mess up my computer trying to do so. Can anyone enlighten me as to what is going on here?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|