101 Tip & Trik
Tuesday, June 16, 2009
Menyisipkan Rumus Index dan Match di VB
Menyisipkan Rumus Index dan Match, gunakan sintaks berikut ini :
Cells(Line, 6).Value = "=INDEX(SOFTWARE.LIST!$A$2:$B$10000,MATCH(E" & Line & ",SOFTWARE.LIST!$A$2:$A$10000,0),2)"
PR:
wait...
I:
wait...
L:
wait...
LD:
wait...
I:
wait...
wait...
Rank:
wait...
Traffic:
wait...
Price:
wait...
C:
wait...
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment