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

·j´MÀɮפ¤¤å¦r¤è¶ô

·j´MÀɮפ¤¤å¦r¤è¶ô

¥­¦w
Àɮפ¤¦³¤@¨Ç¤ô¥­¤å¦r¤è¶ô(¯S®í¦r)
½Ð°Ý¥i¥H¥Î¤°»ò¤èªk§â¥L­Ì¿z¿ï¥X¨Ó ?
¬°¼Æ¤£¤Ö³o¼Ëªº¸ê®Æ , ¦Ó¥B¦b¤£¦PÄæ¦ì
¨Ò¦p
Àɮפ¤ªº B3 B7 A8 A11Äæ¦ì , ¥i¥H¥ÎExcel¿z¿ï¤è¦¡§â¥¦­Ì¿ï¥X¨Ó¶Ü ?

Book2.rar (9.57 KB)

¿z¿ï¤å¦r¤è¶ô

µL¤îºÉªº§V¤O¤W¶i

¥»©«³Ì«á¥Ñ ML089 ©ó 2016-9-1 17:18 ½s¿è

«ö CTRL-D¡A¿ï¯S®í¡A¿ïª«¥ó¡A«ö½T»{¡A·|¿ï¨ú³o¨Ç¶Ã½Xª«¥ó¡A¦A«öDELETE§R°£ª«¥ó¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

¥i¥H§ä¥X¥L­Ìªº¦ì¸m¶Ü ?
µL¤îºÉªº§V¤O¤W¶i

TOP

¦^´_ 3# vinejason


¨º¨Ç¶Ã½X¬Oª«¥ó¡A¥i¥H¥Î¤W­z¤è¦¡¿ï¨ú¡A°O±o³Ì«á¶·«ö½T»{¤~·|¿ï¨ú¡A¦A«öDEL
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

Sub test()
Dim Shp As Shape
For Each Shp In ActiveSheet.Shapes
¡@¡@Shp.TopLeftCell.Interior.Color = vbYellow
Next
End Sub

¦³ª«¥óªºÀx¦s®æ¼Ð¶À¦â

TOP

¦^´_ 4# ML089

ÁÂÁÂML089 ªº¸ÑªR
µL¤îºÉªº§V¤O¤W¶i

TOP

        ÀR«ä¦Û¦b : ªY½à§O¤H´N¬O²øÄY¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD