somevar = Application.Vlookup(lookup_val,lookup_range,3,False)
Sent from my HTC (so please be understanding of any garbled nosnense)
----- Reply message -----
From: "V. Shankar" tarakayan@yahoo.com>
Date: Sat, Jan 26, 2013 07:12
Subject: [ExcelVBA] Using VLOOKUP from Within a VBA Program
To: "ExcelVBA@yahoogroups.com" ExcelVBA@yahoogroups.com>
I use vlookup function extensively. Can you give me an example of how vlookup is used in VBA? thanks, Shankar
>________________________________
> From: David Grugeon yahoo@grugeon.com.au>
>To: ExcelVBA@yahoogroups.com
>Sent: Saturday, January 26, 2013 11:35 AM
>Subject: RE: [ExcelVBA] Using VLOOKUP from Within a VBA Program
>
>
>
>Use match
>
>Best Regards
>David Grugeon
>Excel VBA Group Moderator
>
>-----Original Message-----
>From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
>Of mickey11030
>Sent: Saturday, 26 January 2013 1:18 PM
>To: ExcelVBA@yahoogroups.com
>Subject: [ExcelVBA] Using VLOOKUP from Within a VBA Program
>
>I use VLOOKUP to locate a value from within a VBA program. What I need is
>the row number where the value was found. To get the row number, I added row
>numbers in column 2 to the searched sheet. My statement looks like this:
>
>Range("D2").Formula = "=VLOOKUP(G2,StatTable,2,FALSE)"
>
>I wonder if there is a better way to get the row number.
>
>Any suggestions?
>Thanks,
>Michael Trombetta
>
>------------------------------------
>
>----------------------------------
>Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
>here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
>ARCHIVES for EXCEL VBA.
>
>----------------------------------
>Visit our ExcelVBA group home page for more info and support files:
>http://groups.yahoo.com/group/ExcelVBA
>
>----------------------------------
>More free tutorials and resources available at:
>http://www.mousetrax.com
>
>----------------------------------Yahoo! Groups Links
>
>
>
>
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar