ªÅ¥ÕÀx¦s®æ¦Û°Ê§R°£¡]VBA¡^
- ©«¤l
- 102
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 137
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- 12
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-11-24
- ³Ì«áµn¿ý
- 2018-12-6
|
ªÅ¥ÕÀx¦s®æ¦Û°Ê§R°£¡]VBA¡^
½Ð°Ý¦p¦ó±NªÅ¥ÕÀx¦s®æ§R°£¡]©¹¤W²¾»¼¸É¡^¡A¬Û¹ïªº¸ê®Æ¯à¸òµÛ»¼¸É
ÁÂÁÂ |
-
-
Book1.rar
(4.3 KB)
|
|
|
|
|
|
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
¦^´_ 1# tonycho33 - Columns("C:C").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
½Æ»s¥N½X ³o¦U¤è¦¡À³¸Ó¤ñ¸û²³æ ¬Ý¬Ý¬O¤£¬O§Anªº |
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤l
- 102
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 137
- ÂI¦W
- 0
- §@·~¨t²Î
- winxp
- ³nÅ骩¥»
- 12
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-11-24
- ³Ì«áµn¿ý
- 2018-12-6
|
¦^´_ 2# freeffly
½Ð°Ý¤@¤U§R°£ªÅ¥ÕÀx¦s®æ«á
¨ä¾lÀx¦s®æ¦pªG¦³³sµ²¤½¦¡¡A¤½¦¡³Ì«á·|¶]±¼¡A¥X²{#REF!
n¦p¦ó¸Ñ¨M©O |
|
|
|
|
|
|
- ©«¤l
- 586
- ¥DÃD
- 123
- ºëµØ
- 0
- ¿n¤À
- 763
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOW7
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-16
- ³Ì«áµn¿ý
- 2017-3-14
|
¦^´_ 3# tonycho33
¤£¤Ó©ú¥Õ§Aªº·N«äC
§An¤£n§â§AªºìÀɸê®Æ§ï¹L¶K¤W¨Ó¤ñ¸ûª¾¹D§Aªº°ÝÃD¦bþ? |
|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ
|
|
|
|
|
- ©«¤l
- 106
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 141
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-10-27
- ³Ì«áµn¿ý
- 2016-4-10
|
¤£ª¾¹D¤j¤j¬O¤£¬O³oÓ·N«ä
A 1 = A B1 =1
A 2 = B B2 = ªÅ¥Õ
A 3 = C B3 =B2+1
A 4 = D B4 =B3+1
----------¨Ï¥Îfreeffly ¤j¤jªºVBA«áÅܦ¨----
A 1 = A B1 =1
A 2 = C B2 =#REF!
A 3 = D B3 =#REF!
³o¼Ë©O? |
|
|
|
|
|
|