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

[µo°Ý] ½Ð±Ð¥ý¶i¦p¦ó¨Ï¥ÎVB±N½c¸¹¥[Á`

[µo°Ý] ½Ð±Ð¥ý¶i¦p¦ó¨Ï¥ÎVB±N½c¸¹¥[Á`

½Ð±Ð¥ý¶i¦p¦ó¨Ï¥ÎVB±N½c¸¹¥[Á`¡A¨D¸Ñ¡AÁÂÁÂ

¨D¥ý¶i¸Ñµª

123.jpg

·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

ÁÂÁ½׾Â,ÁÂÁ¦U¦ì«e½ú
«á¾ÇÂǦ¹©«½m²ß°}¦C»P¦r¨å,¾Ç²ß¤è®×¦p¤U,½Ð¦U¦ì«e½ú«ü±Ð

¸ê®Æªí:
20230418_1.jpg
2023-4-18 16:22


°õ¦æµ²ªG:
20230418_2.jpg
2023-4-18 16:22


Option Explicit
Sub TEST()
Dim Brr, Y, i&, xR As Range
Set Y = CreateObject("Scripting.Dictionary")
Set xR = Range([C1], Cells(Rows.Count, "A").End(xlUp)): Brr = xR
For i = 2 To UBound(Brr): Y(Brr(i, 1)) = "": Next
MsgBox "¦@¦³ " & Y.Count & " ­Ó½c¸¹"
Set Y = Nothing: Set xR = Nothing: Erase Brr
End Sub
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD