½Ð°Ý¦p¦ó§â¨âÄ檺¸ê®Æ¦X¨Ö?
- ©«¤l
- 558
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 625
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-5-18
|
¥»©«³Ì«á¥Ñ hugh0620 ©ó 2011-8-11 08:50 ½s¿è
¦^´_ 5# CYC
§Ç1~2 ¬O¥ý§PÂ_FOR¦Ü¤Ön¶]´X°é
§Ç3~8 °õ¦æ°²¦pCÄæ¦ì¨S¦³¸ê®Æ´N±a¥XDÄæ¦ì¸ê®Æ¨Ã§R°£DÄæ¦ì¸ê®Æ- A = Range("C65536").End(xlUp).Row
- B = Range("D65536").End(xlUp).Row
- For I = 1 To Application.Max(A, B)
- If Range("C" & I) = "" Then
- Range("C" & I) = Range("D" & I)
- Range("D" & I).Clear
- End If
- Next
½Æ»s¥N½X |
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|