- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
  
|
¦^´_ 4# PKKO
§Ú°O±o¨S¿ùªº¸Ü¡Aexcel¸Ìªº¤½¦¡³£¯à¦bVBA¸Ì¨Ï¥Î¡A
¥u¬O§Aªº¤½¦¡®æ¦¡n¥´¹ï¡A§A§ï¦¨³o¼Ë´N¯à°õ¦æ¤F¡G
If Application.CountIf(Range("a1:a7"), "2") > 5 Then
§A´N¥ý¼g¥X¤@¯ëªº»yªk¡G=COUNTIF(A1:A7,"2"),
¦ý¬O¦bVBA¸Ì±½d³ò»Ýn¥[Ó"RANGE"¡A©Ò¥H´N·|Åܦ¨¤W±ªº¼Ë¤l¤F¡A
©Î¬O¶û³Â·Ðªº¸Üª½±µ¿é¤J[A1:A7]¤]¥i¥H¨ú¥NRANGE¡C
If Application.CountIf([a1:a7], "2") > 5 Then |
|