ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] excel ¥¨¶°µLªk¹³excel¤º«Ø¤½¦¡¤@¼Ë¶Ü?

¦^´_ 1# PKKO

°ÝÃD¤@¡G¥i¥H¥Îexcel¤½¦¡¡A¦ý­n¦b«e­±¥[­Ó¡yapplication¡z¡AµM«á½d³ò«e­n¥[­Órange("½d³ò")

  If Application.CountA(Range("a1:a7")) > 5 Then

TOP

¦^´_ 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

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD