ȸ¿ø ¹æ¹® ¼ö |
8,351,586 ¸í |
Á¢¼Ó Àοø ¼ö |
4,630 ¸í |
| |
|
Ȩ > ¹¯°í´äÇϱâ |
ÀÚµ¿ÇÊÅÍ(Autofilter)¸¦ °Ë»öÇؼ ÇÊÅÍ°¡ ÀÖÀ¸¸é ÇØÁ¦ÇÒ ¼ö ÀÖ´Â ¸ÅÅ©·Î Äڵ尡 ÀÖ³ª¿ä? |
¿¢¼¿½ÃÆ®»ó¿¡ ºóÇàÀ» »ðÀÔÇÏ°í ½ÍÀºµ¥
½ÃÆ®»ó¿¡ ÀÚµ¿ÇÊÅÍ°¡ Á¸ÀçÇÏ¸é ºóÇàÀÌ »ðÀÔÀÌ ¾ÈµÇ´õ¶ó±¸¿ä~
Range("L3").Select Range(Selection, Selection.End(xlDown)).Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
¿¡¼ ÇÊÅÍ°¡ ÀÖÀ¸¸é ¼¼¹ø° ÁÙ¿¡¼ ¿¡·¯°¡ ³³´Ï´Ù
´äº¯ ºÎŹµå·Á¿ä~
|
ÀÛ¼ºµÈ ÄÚ¸àÆ®°¡ ¾ø½À´Ï´Ù.
|
| |
|
|
|