ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦Û°Ê´£¿ôDel A1

[µo°Ý] ¦Û°Ê´£¿ôDel A1

½Ð°Ý¤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ÀÉ«e­n§â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

¤£¨Ï¥Îvba, ¤S¦p¦ó¥Îmsgbox???
¥Î¤Fvba, ·íµM´N¤£¬O.xlsx®æ¦¡ÀÉ

TOP

§Q¥ÎEXCELªº"¨Ï¥ÎªÌ¦WºÙ", ¨Ó©w¸q®æ¦¡¤Æ±ø¥ó¤½¦¡:
TEST001.rar (10.64 KB)

°£«D¹ï¤èªº¨Ï¥ÎªÌ¦WºÙ»P§A¤@¼Ë~~~
®M¥Î«á, ¥i®³¨ì¥¦¥x¹q¸£¸Õ¸Õ!!!

TOP

¤èªk2:
¦bÀɮצP¼h¸ô®|(¸ê®Æ§¨), «Ø¥ß¤@­Ó¤å¦rÀÉ, ¨Ã©R¦W¬°:_KeyCheck, ·í¦¨Æ_°Í:
TestA.rar (1.83 KB)

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD