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

[µo°Ý] §Æ±æ¼Æ¦r 1 Åܦ¨ 0 ¨ä¥L¼Æ¦r¤£ÅÜ

[µo°Ý] §Æ±æ¼Æ¦r 1 Åܦ¨ 0 ¨ä¥L¼Æ¦r¤£ÅÜ

½Ð±Ð¦U¦ì¤j¤j:

­YA1~A10ªº¼Æ¦r¦p¤U

0 2 5 1 1 3 4 5 6 1

§Æ±æ¼Æ¦r 1 Åܦ¨ 0  ¨ä¥L¼Æ¦r¤£Åܦp¤U  ½Ð°Ý¥ÎVBA¸Ó¦p¦ó¼g?ÁÂÁÂ
0 2 5 0 0 3 4 5 6 0
·PÁ¦U¦ì¦Ñ®vªá¤ß«ä±Ð¾É

¦^´_ 1# jonn0510
  1. Sub Ex()
  2.   Sheets("Sheet1").[A1:A10].Replace 1, 0, xlWhole
  3. End Sub
½Æ»s¥N½X

TOP

¦^´_ 2# register313

register313 ¦Ñ®v:
OK!·PÁ±zªº«ü¾É.ÁÂÁÂ
·PÁ¦U¦ì¦Ñ®vªá¤ß«ä±Ð¾É

TOP

¦^´_ 2# register313
0 2 5 1 1 3 4 5 6 1 §Æ±æ¼Æ¦r 1 Åܦ¨ 0  ¨ä¥L¼Æ¦r¤£Åܦp¤U   0 2 5 0 0 3 4 5 6 0   
¼Ó¥D»¡ªº¬O§ó§ï³¡¥÷¦r¦ê     LookAt °Ñ¼Æ¬O      xlPart
  1. Sub Ex()
  2.   Sheets("Sheet1").[A1:A10].Replace 1, 0, xlPart
  3. End Sub
½Æ»s¥N½X

TOP

¦^´_ 4# GBKEE

¦r¦ê§¹¥þ¬Û¦P¤~¨ú¥N
  Àx¦s®æ½d³ò.Replace ±ý¨ú¥N¦r¦ê,¨ú¥N«á¦r¦ê, xlWhole

¦r¦ê³¡¥÷¬Û¦P§Y¨ú¥N
  Àx¦s®æ½d³ò.Replace ±ý¨ú¥N¦r¦ê,¨ú¥N«á¦r¦ê, xlPart

·íµM­n¨Ì¹ê»Ú»Ý¨D¨Ó¨M©w¨Ï¥Î¦óºØ¨ú¥N(³o¥u¦³¼Ó¥D¤~ª¾¹D¤F)

·PÁÂGBKEE¤j¤j

TOP

¦^´_ 4# GBKEE

GBKEE ¦Ñ®v:
·PÁ±z!§Ú¤S¦h¾Ç·|¤@©Û.ÁÂÁÂ!
·PÁ¦U¦ì¦Ñ®vªá¤ß«ä±Ð¾É

TOP

¦^´_ 5# register313


register313 ¦Ñ®v:
­ì¥»§Ú´N¬O»Ý­n§¹¥þ¬Û¦P¤~¨ú¥N,¤£¹L±z¸Ñ»¡ªº«Ü²M·¡,Åý¤p§Ì¦h¾Ç·|¤@©Û.ÁÂÁÂ!
·PÁ¦U¦ì¦Ñ®vªá¤ß«ä±Ð¾É

TOP

        ÀR«ä¦Û¦b : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD