vba - 命名范围字符串限制

Question

我最近尝试使用自写函数添加命名范围。在玩弄这些名称时，我发现由于某种原因无法添加诸如“nam3”或“3nam”之类的名称，而例如允许使用“name3”。

有人可以向我解释为什么仅使用三个字符与一个数字组合时似乎存在限制吗？或者这种行为是由我不认识的另一种情况引起的？

这是我的简化代码:

Public Sub addNames()
Dim readNames()
Dim i As Integer
Dim rng As Range

readNames = Range("rngNames").value

For i = LBound(readNames, 1) To UBound(readNames, 1)
    Set rng = ActiveSheet.Range(Cells(i, i), Cells(i + 1, i + 1))
    ActiveWorkbook.Names.Add Name:=readNames(i, 1), RefersTo:=rng
Next i

End Sub    

ExcelTestSheet

Answer 1

致nam3和 3nam作为名称范围:

• nam3 is not allowed because it is a cell address (i.e. column NAM and row 3)
• 3nam is not allowed because named ranges cannot start with numbers

坚持 these rules你会没事的: