a vba question. please help# Programming - 葵花宝典
i*a
1 楼
I want to wrote a vba function, which returns the name of a user defined
variable. However, my code seems never work. Could someone please look into
my code and point me out? thank you so much.
Function test(s As String)
Dim a(5) As Integer
For idx = 1 To 5
a(idx) = idx
Next idx
ActiveWorkbook.Names.Add Name:=s, RefersTo:=a
test= s
End Function
variable. However, my code seems never work. Could someone please look into
my code and point me out? thank you so much.
Function test(s As String)
Dim a(5) As Integer
For idx = 1 To 5
a(idx) = idx
Next idx
ActiveWorkbook.Names.Add Name:=s, RefersTo:=a
test= s
End Function