Hi Community,

something strange here, both of these simplest of commands do not work:


Sub Test()

ThisWorkbook.Names.Count

ActiveWorkbook.Names.Add Name:="Test"

End Sub


The .Count statement results in "improper use of a property" (actual error message is in German, so I don't know the exact english wording of the error message).

The .Names.Add results in "application or object defined error".

Excel 2019, Windows 10, VBA.

What am I doing wrong?


Thanks
Markus