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

¥X²{"¨S¦³³]©wª«¥óÅܼƩÎWith°Ï¶ôÅܼÆ"

¦^´_ 1# zamamilo
¨S¦³³]©wª«¥óÅܼƩÎWith°Ï¶ôÅܼƠ  :ª«¥óÅܼƨS³]©w¦n
r = Columns("C").Find("¤p­p:", lookat:=xlWhole).Row   ¨S§ä¨ì "¤p­p" ·|¦³¿ù»~
§ï¦¨:
  1. If Not Columns("C").Find("¤p­p:", lookat:=xlWhole) Is Nothing Then
  2.         r = Columns("C").Find("¤p­p:", lookat:=xlWhole).Row
  3.     Else
  4.         r = 1  
  5.     End If
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD