[Excel VB]請問Vlookup搜尋外部資料的用法,謝謝。
小弟因工作的關係,需要撰寫Excel VB
最近在VB中想用跨活頁簿的方式搜尋我要的資料,但總是出現#value,
由於小弟我是Excel VB新手,對於Sub副程式不太熟。我簡略說一下我的寫法
Function SScan(...略...)
..略..
set myrange = workbooks("abc.xlsx").worksheets("Sheet1").range("A:C")
SScan = application.worksheetfunction.vlookup(略,myrange,2,false)
..略..
End Function
以上Code沒有使用到副程式,其實是不會用= =
所特來此請教各位前輩。感激不盡....
--
Dr. Hannibal Lecter:
Without our imaginations...
we'd be like all those other poor dullars.
Fear is the price of our instrumant.
But I can help you bear it.
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.120.153.147
→
03/18 11:55, , 1F
03/18 11:55, 1F
推
03/19 07:59, , 2F
03/19 07:59, 2F
→
03/19 07:59, , 3F
03/19 07:59, 3F
→
03/19 22:40, , 4F
03/19 22:40, 4F
→
03/19 22:41, , 5F
03/19 22:41, 5F
→
03/19 22:41, , 6F
03/19 22:41, 6F