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

½Ð°Ý¡G¦p¦ó´M§ä¶À¦â©³¦âªºÀx¦s®æ?!

½Ð°Ý¡G¦p¦ó´M§ä¶À¦â©³¦âªºÀx¦s®æ?!

¥»©«³Ì«á¥Ñ candy516 ©ó 2011-1-16 23:55 ½s¿è

¦U¦ì¤j¤j§A­Ì¦n~
½Ð°Ý­n¦p¦ó´M§ä¶À¦â©³¦âªºÀx¦s®æ©O?
§Ú²{¦b¥i¥H´M§äªºÀx¦s­Óªº¤º®e~
(¤ñ¤è»¡§ä¨ì:ÂE®ü:)
Cells.Find(What:="ÂE®ü", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, MatchByte:=False, SearchFormat:=False).Activate
¦ýÁÙ¬OµLªk¼g¥X"§ä¥X¶À©³ªºÀx¦s®æ"?
½Ð°Ý§Ú¸Ó§ï­þ¸Ì©O?
:(

test(2003).rar (369.9 KB)

¦^´_ 22# Hsieh


§A¦n~
½Ð°Ý¿z¿ï¬O­n¥ÎSelection.AutoFilter¶Ü?
¦A½Ð°Ý«e½ú¡A¬O§_¯à°÷¿z¿ï¥X2001~2010¦b10(¤Ñ)¤º¶ñÅvªºªÑ²¼¡A
µM«á¦A±N¿z¿ï¥X¨Óªºµ²ªG©ñ¨ì¤@­Ó·sªºSheet(·Ó¤é´Á±Æ§Ç)?!
¥t¥~¡A«_¬Nªº¦b½Ð°Ý¤@¤U¡A¶ñÅv¤Ñ¼ÆªºÅܼƬO±q­þ¸Ì¨ì­þ?
¦³³¡¤Àªºµ{¦¡¹ï§Ú¨Ó»¡¤Ó²`¶ø¤F!= =
ÁÂÁ§AªºÀ°¦£!

TOP

¦^´_ 21# candy516
§Q¥Î¶ñÅvµ{¦¡¤¤­pºâ¤Ñ¼ÆªºÅܼưµ§PÂ_´N¥i¥H
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 20# FAlonso


¤j¤j§A¦n~
¶ñÅv¤é¼Æ¥Ø«e¤w¸g¸Ñ¨M¤F!
§Ú¥Ø«e©Ò¸I¨ìªº°ÝÃD¬O»¡¡G­n¦p¦ó¿z¿ï¥X¦³¦A"10"¤Ñ¤º§¹¦¨¶ñÅvªºªÑ²¼¡C
©Ò¥H§Ú¥Ø«e¦A¬ã¨s¦p¦ó¿z¿ï¸ê®Æ¡A¶i«×¦³ÂIºC!= =
ÁÂÁ§AªºÀ°¦£!
^^

ªÑ²¼ªÑ§Q¥¼½Õ¾ã¦¬½L»ù(OK).rar (906.87 KB)

TOP

¦^´_  FAlonso


³á~­ì¨Ó¬O³o­Ó·N«ä§r!
²Ä¤G­Óµ{¦¡¤]«Ü¼F®`­C!
¤j®a³£¦n¼F®`­ò!
^^
candy516 µoªí©ó 2011-1-17 21:34

Ãö©ó¨º­Ó¶ñÅv¤é¼Æ,§Ú¿ð¨Ç¼g¤@­Óµ{¦¡µ¹§A
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 17# linshin1999


    linshin1999 §A¦n~
¤]¬O«D±`ÁÂÁ§A§i¶D§Ú¥t¤@ºØ¤èªk!
¤j®aªº³£¦n¦³­@¤ßªº¦^µª§Ú!
ÁÂÁ§A­Ì!

TOP

¦^´_ 16# FAlonso


³á~­ì¨Ó¬O³o­Ó·N«ä§r!
²Ä¤G­Óµ{¦¡¤]«Ü¼F®`­C!
¤j®a³£¦n¼F®`­ò!
^^

TOP

¥»©«³Ì«á¥Ñ linshin1999 ©ó 2011-1-17 19:26 ½s¿è

candy©p¦n:§Ú¾Ç·|¤F¨ú±oÀx¦s®æÃC¦âªº¤èªk,¦pªG¤@©w­n¥ÎÃC¦â§äªº¸Ü,¥i¥H¸Õ¸Õ¬Ý:

Dim mycolor As long
      mycolor = Activecell.Interior.color

¦p¦¹©p´N¥i¥H¨ú±o¥Ø«eÀx¦s®æªºÃC¦â,µM«á±N³o­Ó­È±a¶i¥h¤ì¤uª©¥Dªºµ{¦¡¥h¸Õ¸Õ¬Ý§a!
Sub YY()
Application.FindFormat.Interior.ColorIndex = Activecell.Interior.color
With ActiveSheet
For i = 1 To .Columns.Count
Set c = .Columns(i).Find(What:="", After:=.Cells(65536, i), SearchDirection:=xlNext, SearchFormat:=True)
If Not c Is Nothing Then MsgBox c.Address
Next
End With
End Sub

­ì¨Ó¤w¸g§ä¨ìµª®×¤F,§Ú没¦³¬Ý¨ìÁÙ¦³²Ä¤G­¶,¯u¤£¦n·N«ä,¥i¬O¤w¸g¦¬¤£¦^¨Ó¤F,¤£¹L¤]¾Ç·|¤F¦p¦ó¨ú±oÀx¦s®æªºÃC¦â!
V98

TOP

¦^´_  FAlonso


§A¦n~
½Ð°Ý§Ú°õ¦æ§¹²Ä¤@­Óµ{¦¡½X¥L¶]¥Xªº°T®§¬O"4142"³o¬O¤°»ò·N«ä?!
ÁÂÁ§Aªº¦^µª! ...
candy516 µoªí©ó 2011-1-17 18:05

«ü®æ¤l¬O"µL¶ñº¡".§Ydefaultªºcolor index
¸Óµ{¦¡¬O°»¹î¥X¶À¦âªº½s¸¹,¤£¥Î²q
§Ú²Ä¤G­Óµ{¦¡,§Aı±o«ç¼Ë?
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 14# FAlonso


§A¦n~
½Ð°Ý§Ú°õ¦æ§¹²Ä¤@­Óµ{¦¡½X¥L¶]¥Xªº°T®§¬O"4142"³o¬O¤°»ò·N«ä?!
ÁÂÁ§Aªº¦^µª!
^^

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD