- ©«¤l
- 913
- ¥DÃD
- 150
- ºëµØ
- 0
- ¿n¤À
- 1089
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- office 2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-8-28
- ³Ì«áµn¿ý
- 2023-7-19
|
½Ð°Ý¤j¤j,
¦³¤@Ó¦@¥ÎÀÉ,¨C¦¸¥´¶}n¶}©l§@·~«e,n¥ý¦b
Workbooks("®w¦s.xlsx").Sheets("¥]§÷").Range("A1")
¿é¤J¤@Ó«ü©w¼Æ¦r,¤~¯à¬Ý±o¨ì¤º®e(¦]¬°¦³³]©w±ø¥ó¤Æ±ø¥ó)
¦]¬°ÀɮצP®É¤]·|±Hµ¹«È¤H,¦b¦sÀÉ«en§âA1ªº¤º®eDelete,
«È¤H´NµLªk¤@²´¬Ý¨ì¤£·QÅã¥Üªº¸ê®Æ,¦ý¨Ï¥ÎªÌ±`§Ñ¤F§âA1ªº¤º®eDelete,
½Ð°Ý¥H¤U¤GÂI(¾Ü¤@),¦³¦ó¤è¦¡¥i¥H°µ¨ì??
(¤£¨Ï¥ÎVBA, ¦]¬°Àɮ׮榡n¦s¦¨.xlsx)
1) ¦sÀÉ«eA1ªº¤º®e¥¼Delete,«h¥X²{Msgbox>>"A1Àx¦s®æ½ÐDelete"
2) ¦sÀÉ«e¦Û°ÊDelete A1ªº¤º®e |
|