search

hilkoc / vbaDeveloper

Tools for development and version control of vba code
MIT License
510 stars 138 forks source link

NamedRanges do not import properly #47

Open no-name-2 opened 4 years ago

no-name-2 commented 4 years ago

After exporting and importing named ranges they are kind of broken. For example, the output of "?ThisWorkbook.Names("MyName").RefersTo" should be something like "='Table1'!$A$1", but somehow it tends to be "='Table1'!R1C1", which should be the output of .RefersToR1C1 . What was originally exported does still have the right "$A$1$ format.

hilkoc commented 4 years ago

This has to do with a particular setting in Excel, but I forgot which one.