½Ð°ÝVBA»s§@¥|¯Z¤G½ü¯Zªí°ÝÃD
- ©«¤l
- 21
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 58
- ÂI¦W
- 0
- §@·~¨t²Î
- Win8
- ³nÅ骩¥»
- Excel 2.0
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2016-3-17
- ³Ì«áµn¿ý
- 2024-1-13
|
½Ð°ÝVBA»s§@¥|¯Z¤G½ü¯Zªí°ÝÃD
½Ð°Ý¦pªGn¦p¦P¹Ï¥Ü¡A¤G¤Ñ©³¦ân¤£¤@¼Ë¡A¸Ó¦p¦ó¼g©O¡AÁÂÁ¦U¦ì
|
|
|
|
|
|
|
- ©«¤l
- 1391
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1401
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-12-16
|
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 4
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- win7
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2016-11-3
- ³Ì«áµn¿ý
- 2021-11-21
|
ø¡A¬°¤°»ò§Ú¬d¨ìªº½s¸¹¬O6436©O?
https://blog.xuite.net/hcm19522/twblog/588775126
¤£¹LÁÂÁÂH¤j¸Ñ¨M§Úªº°ÝÃD¡C |
|
|
|
|
|
|
- ©«¤l
- 17
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 67
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7 & Win10
- ³nÅ骩¥»
- Office 2003 & Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2020-2-4
- ³Ì«áµn¿ý
- 2024-4-19
|
ø¡A¬°¤°»ò§Ú¬d¨ìªº½s¸¹¬O6436©O?
https://blog.xuite.net/hcm19522/twblog/588775126
¤£¹LÁÂÁÂH¤j¸Ñ¨M§Ú ...
lin0902 µoªí©ó 2020-8-30 23:22
¤£¦n·N«ä!!§Ú¬Ý¤£À´³o¬O¤°»ò·N«ä?
®æ¦¡¤Æ (²Ä¤G¦æ¦rÅé¦Ç¦â) C2:I2=C2>15
®æ¦¡¤Æ (²Ä¤¤»¦æ¦rÅé¦Ç¦â) C6:I7=C6<15
®æ¦¡¤Æ (¤G®æ¬õ¦â ¤G®æªÅ) C2:I7=IF(ROW(A1)=1,C2<15,IF(ROW(A1)>4,C2>15,1))*(MOD(DATE($A$2,$A$5,C2),4)<2)
½Ð°Ý³onþÃä¥Î? |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 4# Muffledsatyr
Àx¦s®æªº³]©w®æ¦¡¤Æ±ø¥ó - ¨Ï¥Î¤½¦¡¨Ó³]©w®æ¦¡¤Æ
¤£¦n·N«ä!!§Ú¬Ý¤£À´³o¬O¤°»ò·N«ä?
®æ¦¡¤Æ (²Ä¤G¦æ¦rÅé¦Ç¦â) C2:I2=C2>15
ªí¥Ü¿ï¾Ü C2:I2 Àx¦s®æªº³]©w®æ¦¡¤Æ±ø¥ó¡A¿é¤J¤½¦¡ =C2>15¡A¦A¿ï¾Ü¦rÅ鬰¦Ç¦â |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|