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

§ä¤é´Á¥X²{ "°õ¦æ¶¥¬q¿ù»~'91':¨S¦³³]©wª«¥óÅܼƩÎWith°Ï¶ôÅܼÆ"

§ä¤é´Á¥X²{ "°õ¦æ¶¥¬q¿ù»~'91':¨S¦³³]©wª«¥óÅܼƩÎWith°Ï¶ôÅܼÆ"

Sub ¤é´Á¸õÂà()
'Âà´«¤é´Á
Dim today As Date
Sheets("¥D­¶").Select
   x = Range("J1").Value
DateValue (x)
MsgBox "" & x
Sheets("·í¤é¦¬¤ä").Select
Cells.Find(What:="" & x, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
        xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
        False, SearchFormat:=False).Activate
End Sub

"°õ¦æ¶¥¬q¿ù»~'91':¨S¦³³]©wª«¥óÅܼƩÎWith°Ï¶ôÅܼÆ"

­ì¥»§äªº¨ìÃö±¼­«¶}´N¤£¦æ¤F

[ª©¥DºÞ²z¯d¨¥]
  • GBKEE(2016/3/7 19:01): ªþÀɬݬݤ~²M·¡¨º¸Ì¥X¿ù¡C

¦³¤H¥i¥HÀ°¦£¸Ñµª¶Ü~~~¥u­n¯à°÷Àò¨úJ1ªº¤é´ÁµM«á¦b§Oªº¤À­¶§ä¨ì¨º¤Ñªº¤é´Á´N¦n¤F~~~

TOP

¤w¸Ñ¨M·PÁÂ

TOP

¦^´_ 4# asd16801680

Cells.Find(What:=x, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
        xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
        False, SearchFormat:=False).Activate
End Sub
xª½±µ³]´N¦n

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