[VBA ] Function 傳回值
剛碰 VBA，不知道該怎麼讓具傳回值
例如
Function AddSheet() As Worksheet
AddSheet2 = Worksheets.Add
' always display 沒有設定物件變數 或 with 區塊變數
End Function
Sub AddSheet()
Dim x As Worksheet
Set x = AddSheet2
End Sub
不知是否哪裡語法或觀念方面有問題？
謝謝各位先進。
--
If there is no tomorrow,
I want to see u last time.
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 180.177.76.142
→
01/21 00:16, , 1F
01/21 00:16, 1F
→
01/21 00:16, , 2F
01/21 00:16, 2F
→
01/21 00:21, , 3F
01/21 00:21, 3F