¶Ã¼Æ±a¤JRAND¡A¦p¦ó¸Õºâ¥X¤p¼ÆÂI«á±³£¥h±¼
- ©«¤l
- 12
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- Excel.PowerPoint.Word
- ³nÅ骩¥»
- 2010.2013.2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- »OÆW
- µù¥U®É¶¡
- 2016-12-6
- ³Ì«áµn¿ý
- 2021-2-23
|
¶Ã¼Æ±a¤JRAND¡A¦p¦ó¸Õºâ¥X¤p¼ÆÂI«á±³£¥h±¼
½Ð°Ý¦U¦ì¤j¤j¡ã¡ã
¥H¤U¹Ï¥Ü·Q°Ý¡A¦p¶Ã¼Æ±a¤J=RAND()*(215-(1))+(1)....... EXCELÀx¦s®æ¤º¦p¦ó¸Õºâ¥X¤p¼ÆÂI«á±³£¥h±¼??
§Ú¤£·Q¥HÀx¦s®æ¦U¦¡->¼ÆÈ->¤º³]©w
þÓ¤j¤j¥i¥H±Ï§Ú~~[attachimg]32247[/ |
|
Helen
|
|
|
|
|
- ©«¤l
- 262
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 280
- ÂI¦W
- 17
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- HK
- µù¥U®É¶¡
- 2015-8-11
- ³Ì«áµn¿ý
- 2024-11-19
|
|
|
|
|
|
|
- ©«¤l
- 12
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- Excel.PowerPoint.Word
- ³nÅ骩¥»
- 2010.2013.2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- »OÆW
- µù¥U®É¶¡
- 2016-12-6
- ³Ì«áµn¿ý
- 2021-2-23
|
¦^´_ 2# ikboy
¤j¤j~~ µLªk¤]!!! |
|
Helen
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 1# §d¼ü¼ü
Sub ex1()
Range("A7:A26") = "=int(rand()*(215-(1))+(1))"
Range("A7:A26") = Range("A7:A26").Value
End Sub |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 1# §d¼ü¼ü
Sub ex1()
'¶Ã¼Æpºâ«á¨ú¾ã¼Æ
Range("A7:A26") = "=int(rand()*(215-(1))+(1))"
Range("A7:A26") = Range("A7:A26").Value
'±Æ§Ç
Range("a7:a26").Sort key1:=Range("a7"), order1:=xlAscending, Header:=xlNo
End Sub |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 12
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- Excel.PowerPoint.Word
- ³nÅ骩¥»
- 2010.2013.2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- »OÆW
- µù¥U®É¶¡
- 2016-12-6
- ³Ì«áµn¿ý
- 2021-2-23
|
¦^´_ 5# ML089
ÁÂÁ¿߿ߤj¤j¡ã~~ þ¥i¥Hµ{¦¡¥[¤W¤£«½Æªº¼Æ¶Ü?¡@¤]´N¬O»¡¶Ã¼Æ¡Ï¤£«½Æ¡Ï±Æ§Ç |
|
Helen
|
|
|
|
|
- ©«¤l
- 1392
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1402
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-12-26
|
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 6# §d¼ü¼ü
Sub ex1()
'¶Ã¼Æpºâ«á¨ú¾ã¼Æ
Range("A7:A26") = "=int(rand()*(215-(1))+(1))"
Range("A7:A26") = Range("A7:A26").Value
'±Æ§Ç
Range("a7:a26").Sort key1:=Range("a7"), order1:=xlAscending, Header:=xlNo
'¨ú°ß¤@
ActiveSheet.Range("A7:A26").RemoveDuplicates Columns:=1, Header:=xlNo
End Sub |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 12
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- Excel.PowerPoint.Word
- ³nÅ骩¥»
- 2010.2013.2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- »OÆW
- µù¥U®É¶¡
- 2016-12-6
- ³Ì«áµn¿ý
- 2021-2-23
|
¦^´_ 8# ML089
ÁÂÁ¿߿ߤj¤j~~~ |
|
Helen
|
|
|
|
|