Ahk语法如何在excel中创建一个名称

遇到了问题?请先进行搜索(中文和英文),然后在此提问

Moderators: tmplinshi, arcticir

dlliuyi333
Posts: 4
Joined: 14 Apr 2015, 21:53

Ahk语法如何在excel中创建一个名称

21 Mar 2018, 23:11

各位大神好

Vba中有这样一段代码:
ActiveSheet.Names.add name:="pic",RefersToR1C1:="=get.cell(24,$C1)"
请问,如果是用ahk来编写,该如何转换,谢过大神了。
aamii
Posts: 47
Joined: 23 May 2014, 03:50

Re: Ahk语法如何在excel中创建一个名称

12 Jul 2018, 00:38

转用vba的函数方式添加。

Code: Select all

oExcel.ActiveWorkbook.Names.Add("pic", "=" oExcel.range("B1:C5").address())

Return to “请求帮助”

Who is online

Users browsing this forum: No registered users and 10 guests