Workbook.Names not working

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

Silly me, of course the .count has to have put somewhere.
I had .refersto but did not think of R1C1
Thanks, works now.

But the same in vb.net via ExcelDNA does not work:

Please Login or Register  to view this content.

The counts both work (0 for wb.names.count and 1 for tempRng.Rows.Count) but none of the .Add statements.

What am I missing?