Excel 用function 傳出陣列值
sub test1()
x=1
y=2
arr= AAA(x,y)
end sub
function AAA(x,y)
dim arr(1 to 2,1 to 2)As Variant
arr(1,1)=11
arr(1,2)=12
arr(2,1)=21
arr(2,2)=22
AAA=arr
end function
x=1
y=2
arr= AAA(x,y)
end sub
function AAA(x,y)
dim arr(1 to 2,1 to 2)As Variant
arr(1,1)=11
arr(1,2)=12
arr(2,1)=21
arr(2,2)=22
AAA=arr
end function
留言
張貼留言