- ©«¤l
- 824
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 904
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2023-12-24
|
¥»©«³Ì«á¥Ñ luhpro ©ó 2012-9-22 04:16 ½s¿è
¦^´_ luhpro
¦^Luhpro
¤p§Ì¨Ì±z«Øij¡A±N¦r®¿¨ìAÄæ«á¦A°õ¦æ¡Aªº½T´N¯à§ïÅܦrªºÃC¦â¡A·PÁ±z ...
syuan µoªí©ó 2012-9-21 11:59
¤£ª¾¹D¬O¤£¬Oª©¥»¤£¦Pªºì¦],
§Ú¶]§Aªºµ{¦¡¨Ã¤£·|Åܦâ(sheet1 »P sheet3 ³£Åã¥Ü I can't)
¦ü¥G»P§A©Ò±Ôzªºµ²ªG¤£¦P,
³o¼Ë´NµLªk§ä¨ì°ÝÃDªºÄpµ²¤F.
³o¸Ì¹Á¸Õ´£¥X´XÓ«Øij¬Ý¬O§_¯à§ä¨ì°ÝÃDÂI:
1. ¨Ï¥Î³æ¨B°õ¦æ(«ö F8 «öÁä)°õ¦æ¦Ü°±¦b If ¨º¦æ,
¦A©ó§Y®É¹Bºâµøµ¡¥ý Key ¤@Ó ? ¨Ã©ó¨ä¥k¤è½Æ»s«á¶K¤W±ø¥ó¦¡ªº¤º®e,
(§Y ?Worksheets("sheet3").Cells.Font.Color = vbRed )
¬Ý¬Ý¨t²Îµ¹¥Xªº±ø¥ó¦¡§PÂ_µ²ªG¬°¦ó,
---> §Ú¬Ý¨ìªº¬O Null (Áö«D¬Û¦P¦ýµ²ªG±µªñ «D¯u<True> )
2. ¦A²Ó³¡¤@ÂI©ó ? ¥k¤è¤À§O±µ¤W±ø¥ó§PÂ_¦¡¤¤ = ¥ªÃä »P ¥kÃä ªº¤º®e,
¬Ý¬Ý¨t²Î§i¶D§Ų́âÃ䪺¹Bºâµ²ªG¦U¬O¤°»ò?
(§Y ?Worksheets("sheet3").Cells.Font.Color »P ?vbRed )
---> §Ú¬Ý¨ìªº¬O Null »P 255
3. §Ṳ́]¥i¥H½T»{³æ¤@Àx¦s®æªº¤å¦rÃC¦â¥N½X¬O¦h¤Ö,
¨Ò : ?Worksheets("sheet3").[A1].Font.Color
§A¥i¥H¸Õ¸Õ¬Ý¤À§O±N¨âÓÀx¦s®æ³]¦¨ ¶Â¦â »P ¦Û°Ê ¦A´ú¬Ý¬Ý¬O§_¨t²Î·|Åã¥Ü¤£¦P¦â½X.
---> §Ú¬Ý¨ìªº³£¬O 0
¨ä¹ê¦b§A´£¨Ñªº¹Ï¤ù¤W´N¥i¥H¬Ý¥X¨Ó,
"¦Û°Ê" ¨ºÓ¿ï¶µªº¥ª¤è¦³Ó¤è®æ¥¦ªºÃC¦â´N¦³§i¶D§A¥Ø«e "¦Û°Ê" ©Ò¹ïÀ³ªºÃC¦â´N¬O¶Â¦âªº.
4. ¤£½×¬O .Range("A1:AZ1000") ÁÙ¬O .cells ³£¬O¦bªí¥Ü "¦hÓÀx¦s®æ",
¥¦¨Ã¤£¾A¦X¥Î©ó If «ü¥Oªº§PÂ_¤W,
¦]¬°¨ä¤¤ªº¦UÓÀx¦s®æ¥i¥H¤À§O¦³¤£¦PªºÃC¦â,
³o±N¾ÉP§PÂ_¦¡ªºµ²ªG¬°µLªk½T»{µ²ªG(Null).
n¹ï¦hÓÀx¦s®æ§@§PÂ_¦¡ªº³B²z,
À³¸Ó¦b¨ä¥~¥ý®M¥Î For Each »P Next ¥Hªí¥Ü¨Ì§Ç¹ï¨ä¤º©Ò¦³ªºÀx¦s®æ§@§PÂ_»P³B²z.
«Øijµ{¦¡½X¦p¤U :- Worksheets("sheet3").Activate
- Dim a As Range
-
- For Each a In Worksheets("sheet3").[B2].CurrentRegion
- If a.Font.Color = vbRed Then a.Font.Color = vbBlack
- Next
½Æ»s¥N½X |
|