- ©«¤l
- 522
- ¥DÃD
- 36
- ºëµØ
- 1
- ¿n¤À
- 603
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp sp3
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-12-13
- ³Ì«áµn¿ý
- 2021-7-11
|
¦^´_ 8# Qektyyrwp
¸Õ¸Õ¬Ý:
1. ¥X¯Ê¶Ô§Op®É³¡¥÷, ¥½2¦ì¥þ³¡½s׬°
¦~¥ð10
¦~¥ð04
¦~¥ð08
¨Æ°²02
¨Æ°²04
... ...
... ...
¨Æ°²AA
«Dp®É³¡¥÷¤£ÅÜ
2. vba³¡¤À
¥Î --RIGHT ·j´M,
±N --RIGHT(E7,1) §ï¬° --RIGHT(E7,2)
(§Y, ì¥k¨ú1¦ì, §ï¬°¥k¨ú2¦ì)
(¦@3³B)
ActiveWorkbook.Names.Add Name:="rr", RefersToR1C1:="=--RIGHT(ww,2)"
ActiveWorkbook.Names.Add Name:="rm", RefersToR1C1:="=--RIGHT(wm,2)"
3. ½s¿è§¹½Ð«ö ¸ê®Æ«¾ã |
|