½Ð°Ý¤Gºû±`¼Æ°}¦C¥Îvba¸Ó¦p¦ó¼g¡H
- ©«¤l
- 32
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 68
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- «n§ë¿¤
- µù¥U®É¶¡
- 2010-9-28
- ³Ì«áµn¿ý
- 2019-10-4
|
½Ð°Ý¤Gºû±`¼Æ°}¦C¥Îvba¸Ó¦p¦ó¼g¡H
¦U¦ì«e½ú¤j®a¦n¡G¦V¦U¦ì½Ð±Ð¤Gºû±`¼Æ°}¦Cªº¼gªk¡C
[Range].FormulaArray = "={1,2,3;4,5,6}"¡A³oºØ¼gªk¤£¬O§Únªº¡A§Únªº¬O¨Ò¦p:
¤@ºû°}¦Cªº¼gªk¡Garray (1,2,3)
¤Gºû°}¦C¸Ó¦p¦ó¼g¡H¡Garray((1,2,3);(4,5,6))³o¼gªk¦ü¥G¦æ¤£³q¡A½Ð¦U¦ì¤j¤j½ç±Ð¡AÁÂÁ¡I¡I |
|
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 247
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-14
|
¦^´_ 1# sptakung1
n¬Ý§A°}¦Cªº¥Î³~¥i¯à¦³¤£¦P°µªk
¥ÎÓ²³æ¨Ò¤l§A°Ñ¦Ò¬Ý¬Ý- Sub nn()
- ar1 = Array(1, 2, 3, 4, 5)
- ar2 = Array(6, 7, 8, 9, 10)
- ar = Array(ar1, ar2)
- MsgBox Application.HLookup(3, ar, 2, 0)
- End Sub
½Æ»s¥N½X |
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|
- ©«¤l
- 13
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 18
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2012-9-29
- ³Ì«áµn¿ý
- 2012-10-10
|
¬O§_Ãþ¦ü³o¼Ë?- Dim m(2, 2)
- m(1, 1) = 1 : m(2, 1) = 3
- m(1, 2) = 2: m(2, 2) = 4
½Æ»s¥N½X |
|
«Ü¦h¨Æ±¡¡A¶}©l°µ¤F¤§«á¤~µo²{«Ü²³æ¡A
¯u¥¿Ãøªº¬O«ç»ò§¹¬ü¦aµo´§¦Û¨ªºª¬ºA¡C
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¥»©«³Ì«á¥Ñ c_c_lai ©ó 2012-10-9 11:02 ½s¿è
¦^´_ 1# sptakung1
¤Þ¥Î Hsieh ª©¤jªº½d¨Ò¡A¤]¥i¥Hª½±µ¨úÈ¡C- Sub nn2()
- ar = Array(Array(1, 2, 3, 4, 5), Array(6, 7, 8, 9, 10))
- MsgBox "Application.HLookup(3, ar, 2, 0) ¨ä¶Ç¦^È " & _
- Application.HLookup(3, ar, 2, 0) & Chr(10) & _
- " µ¥©ó ar(1)(2) ªº¤Gºû°}¦CÈ " & ar(1)(2) & ""
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 68
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- «n§ë¿¤
- µù¥U®É¶¡
- 2010-9-28
- ³Ì«áµn¿ý
- 2019-10-4
|
¦^´_ 2# Hsieh
Hsieh¶Wª©ÁÂÁ±z¦n¡G
¥N½Xar = Array(ar1, ar2)´N¬O§Únªº¡A«D±`·P¿E±zªº¼ö¸ÛµªÂСCÁÂÁ¡C
#3¡B#4¼Óªº¼Ó¥D¡A¤]«D±`·PÁ§A̪º¼ö±¡¦^À³¡C
¦b¦¹¦V¦U¦ì¹DÁ¡C |
|
|
|
|
|
|