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

½Ð±ÐÀH¾÷ ­­©w°ª¤â

½Ð±ÐÀH¾÷ ­­©w°ª¤â

½Ð±ÐÀH¾÷­­©w°ª¤â..
vb©Î¨ç¼Æ¼gªk³£¥i..ÀH¾÷¼Æ­­©w..

»¡©ú©óªþ¥ó¤º..ÁÂÁ !

ÀH¾÷¼Æ.rar (7.84 KB)

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522

¦^¤j¤j:¦ü¥G½Æ»s¥k°Õ.­þ­Óµ´¹ï¦ì§}¥X¿ù?
    C3 ¥X²{¤j©óC2  ½Ð«ü±Ð...ÁÂÁÂ!

TOP

¦^´_ 1# duck_simon


    ÁÂÁÂÁ«e½úµoªí¦¹¥DÃD»P½d¨Ò
«á¾Ç¾Ç²ß«Øij¤è®×¦p¤U:

20230908-1.jpg
2023-9-8 16:40


Option Explicit
Sub TEST()
[B4:E4].ClearContents
Do Until [B4] <> [C4]
[B4] = 41 + Int((Rnd() + 1) * 10 ^ 6) Mod 9
[C4] = 41 + Int((Rnd() + 1) * 10 ^ 6) Mod 9
Loop
Do Until [D4] <> [E4]
[D4] = 51 + Int((Rnd() + 1) * 10 ^ 6) Mod 9
[E4] = 51 + Int((Rnd() + 1) * 10 ^ 6) Mod 9
Loop
End Sub
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 3# duck_simon

区°ì数组¤½¦¡ :¤½¦¡¤UB3-->ENTER-->°é¿ïB3:C3->´å¼Ð©ñ¤½¦¡¤W-->shift+ctrl+enter¤TÁä¤@°_«ö   ¤è¦¡¤G¸û²³æ
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ duck_simon ©ó 2023-9-8 18:20 ½s¿è

¦^´_ 4# Andy2483


     ·PÁ¤j¤jªºVB §Úª¾¹D±z¬O°ª¤â..¦ý§Ú¥X²{³o­Ó..­þ¸Ì
2023-09-08_180700_page-0001.jpg
2023-9-8 18:19
­n§ó§ï? "¤£¥¿½Tªº¤º³¡µ{§Ç"

TOP

¥»©«³Ì«á¥Ñ duck_simon ©ó 2023-9-8 18:28 ½s¿è

¦^´_ 5# hcm19522


    ¦^¤j¤j°ª¤â..¥¿§V¤O´ú¸Õ¤¤  ¦¨¥\!  ·PÁ°ª¤â

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD