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

Post a reply


In an effort to prevent automatic submissions, we require that you complete the following challenge.
Smilies
:D :) ;) :( :o :shock: :? 8-) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :!: :?: :idea: :| :mrgreen: :geek: :ugeek: :arrow: :angel: :clap: :crazy: :eh: :lolno: :problem: :shh: :shifty: :sick: :silent: :think: :thumbup: :thumbdown: :salute: :wave: :wtf: :yawn: :facepalm: :bravo: :dance: :beard: :morebeard: :xmas: :HeHe: :trollface: :cookie: :rainbow: :monkeysee: :monkeysay: :happybday: :headwall: :offtopic: :superhappy: :terms: :beer:
View more smilies
BBCode is ON
[img] is OFF
[flash] is OFF
[url] is ON
Smilies are ON
Topic review
   

Expand view Topic review: Ahk语法如何在excel中创建一个名称

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

Post by aamii » 12 Jul 2018, 00:38

转用vba的函数方式添加。

Code: Select all

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

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

Post by dlliuyi333 » 21 Mar 2018, 23:11

各位大神好

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

Top