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

½Ð°Ý´¡¤J ·j´M¥\¯à

½Ð°Ý´¡¤J ·j´M¥\¯à

½Ð°Ý­n«ç»ò¦bexcel¸Ì­±´¡¤J·j´M¥\¯à, ¨Ã¥i¦Û°Ê¬D¨ì²Å¦X·j´M¤å¦rªºÄæ¦ì©O

¦pctrl+Fªº·j´M¥\¯à §ä¨ì¤§«á ¦Û°Ê¸õ¨ì¸Ó¦ì¸m

TOP

¦^´_ 2# starry1314
µ½¥Î "¿ý»s·s¥¨¶°" ¥\¯à, ¥i±o¨ì¦p¤U«ü¥O :
  1. Sub Macro1()
  2. '
  3. ' Macro1 ¥¨¶°ªí
  4. ' ccc ¦b 2015/4/29 ¿ý»sªº¥¨¶°
  5. '

  6. '
  7.     Cells.Find(What:="1", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
  8.         xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) _
  9.         .Activate
  10. End Sub
½Æ»s¥N½X

TOP

¥»©«³Ì«á¥Ñ starry1314 ©ó 2015-4-29 22:23 ½s¿è

¦^´_ 3# luhpro



§Ú¦³¿ý»s¥X¨Ó,¦ýµLªk«ü©w«ö¶s¨Ï¥Î »¡¨S¦³«ü©wª«¥ó
¥t³o¥i¥HÂIÀ»¤U¥h¥X²{·j´M®Ø®Ø¶Ü?
¬õ¦r³¡¤À½Ð°Ý­n¦p¦ó¹F¦¨ÂIÀ»¤U¥h¨Ì§Ú¿é¤J¤å¦r¨Ó´M§ä©O?
¦]²{¦bÅܦ¨¹w³]¥u¯à§ä1



'
    Range("H17").Select
    Cells.Find(What:="1", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
        xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
        , SearchFormat:=False).Activate
End Sub

TOP

¦^´_ 3# luhpro


    ¥D­n¬O·Q°µÃöÁä¦r·j´M¥\¯à, ±qA~ZÄæ
¿é¤J³¡¤ÀÃöÁä¦r¥i¦Û°Ê¸õ¨ì²Å¦X¸Ó±ø¥óªºÄæ¦ì§Y¥i

¿ý»sªº¥¨¶°Åܦ¨¬O«ü©wªº,¤£ª¾¸Ó«ç­×§ï¥i¨Ì¾Ú¬YÄæ¦ìªº±ø¥ó°µ·j´M©Î¬O¸õ¥X²M³æ¦A¿é¤JÃöÁä¦r

TOP

¦^´_ 5# starry1314

­×§ï¤U­±³o
    LookAt:=xlPart

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2015-4-30 00:57 ½s¿è
¦^´_  luhpro
§Ú¦³¿ý»s¥X¨Ó,¦ýµLªk«ü©w«ö¶s¨Ï¥Î »¡¨S¦³«ü©wª«¥ó
¥t³o¥i¥HÂIÀ»¤U¥h¥X²{·j´M®Ø®Ø¶Ü ...
starry1314 µoªí©ó 2015-4-29 22:11

§ï¦¨³o¼Ë :
  1. Cells.Find(What:=[H17], After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
  2.         xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) _
  3.         .Activate
½Æ»s¥N½X
¦^´_  luhpro
    ¥D­n¬O·Q°µÃöÁä¦r·j´M¥\¯à, ±qA~ZÄæ
¿é¤J³¡¤ÀÃöÁä¦r¥i¦Û°Ê¸õ¨ì²Å¦X¸Ó±ø¥óªºÄæ¦ì§Y ...
starry1314 µoªí©ó 2015-4-29 23:07

­n¥s¥X·j´Mµe­±¥u­nª½±µ¼ÒÀÀ¨Ï¥ÎªÌ«ö¤U Ctrl+F «öÁä§Y¥i,¦p¤U«ü¥O:

SendKeys "^f"

¤§«á´N¥i¥Hª½±µ¿é¤J­n·j´Mªº¤å¦r.

TOP

§ï¦¨³o¼Ë :
­n¥s¥X·j´Mµe­±¥u­nª½±µ¼ÒÀÀ¨Ï¥ÎªÌ«ö¤U Ctrl+F «öÁä§Y¥i,¦p¤U«ü¥O:

SendKeys "^f"

¤§«á ...
luhpro µoªí©ó 2015-4-30 00:56



    ·PÁ¤À¨É~¤w¸Ñ¨M¡I¡I

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD