Excel VBA vlookup Columns 使用變數:Realtime－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中

Excel VBA vlookup Columns 使用變數

Mar 10th 2015, 19:10

請問一下 Excel VBA Vlookup 比對範圍使用變數

只有1用數值路徑可以搜尋的出來
其他用變數 , 或是 CHR(64+ S1 or S2) 都找不出來
可以請大家幫忙找一下問題嗎??

S1=C
S2=D

1.
Sheets("Sheet1").Range("D6") = Application.VLookup(Sheets("Sheet3").Range("A6"), Sheets("Sheet3").Columns("C:D"), 2, False)
2.
'Sheets("Sheet1").Range("D6") = Application.VLookup((Sheets("Sheet3").Range("A6"), Sheets("Sheet3").Columns(S1& ":" & S2), 2, False)
3.
'Sheets("Sheet1").Range("D6") = Application.VLookup((Sheets("Sheet3").Range("A6"), Sheets("Sheet3").Columns(Chr(64 + S1) & ":" & Chr(64 + S2)), 2, False)

This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions