如下图所示
当用vba给excel工作簿添加如上图所示的公式名称“计算文本字符串”,代码如下:
1 2 3 4 5 6 7 |
Sub QQ1722187970() Dim oName As Name Dim oWB As Workbook Dim oWK As Worksheet Set oWB = Excel.ThisWorkbook Set oName = oWB.Names.Add(Name:="计算文本字符串", RefersTo:="=EVALUATE(Sheet1!A1)") End Sub |
会显示如下图所示的错误:[……]
阅读全文>>>