¿À´ÃÀº VBA Áú¹®À» °¡Á®¿Ô½À´Ï´ç.
¿¢¼¿·Î ¶óº§Áö Ãâ·ÂÇÏ·Á°í Çߴµ¥¿ä.
¾Æ´Â ³»¿ëÀ̶ó ÀÛµ¿ÇÏ°Ô´Â ¸¸µé¾ú´Âµ¥, ÀÌÇØ ¾È°¡´Â ºÎºÐÀÌ ÀÖ¾î¼, Áú¹® µå¸³´Ï´Ù!
¹æ¹ýÀÌ¾ß ¸¹°ÚÁö¸¸ ±×³É ¸· ´Ü¼øÇÏ°Ô ¸¸µé¾ú¾î¿ä.
Sub PrintAll_Click()
Dim i As Integer
Dim CntA As Integer
CntA = Application.WorksheetFunction.CountA(Range("B2:B100"))
For i = 0 To CntA
If i = CntA Then GoTo out
Sheets("print").Cells(1, 1) = Sheets("print_list").Cells(2 + i, 2)
Sheets("print").PrintOut
Next i
out:
End Sub
¼¿Áß¿¡ ³»¿ë ÀÖ´Â ¼¿ °¹¼ö¸¸ ¼¼¼ CntA º¯¼ö¿¡ ³Ö°í, i °¡ 0ºÎÅÍ CntA µÉ¶§±îÁö ¹Ýº¹µÇµµ·Ï ÇÏ´Â ±¸¼ºÀä.
¼¿ ³»¿ë¿¡ 2°³°¡ ÀÖÀ¸¸é, i °¡ 0 To 2 °¡ µÇ´Ï±î..........................
=============================================================================
¿Ö ÀÚ²Ù Àǹ̾øÀÌ CntA°¡ 2Àε¥ 3¹ø ¹Ýº¹µÅ¼ ¾µµ¥¾ø´Â ÀÚ·á°¡ Çϳª ´õ Ãâ·ÂµÇ³ª Çß´õ´Ï -_-;;;
i°¡ 0ºÎÅÍ 2´Ï±î 0, 1, 2 ¶ó¼ ´ç¿¬È÷ ¼¼¹ø µµ´Â°Çµ¥ ¿Ö±×·¯´ÂÁö °í¹ÎÇ߳׿ä -_-;;;
ÀÌ°É ¸ô¶ó¼ Áß°£¿¡ ÀÌÇÁ ½á¼ °Á¦·Î ¹Ýº¹¹® Å»Ãâ½ÃÄ״µ¥....
i ½ÃÀÛÀ» 1·Î ¹Ù²Ù°í, i°¡ ´õÇØÁö´Â ºÎºÐ¿¡¼ 1À» »« °ªÀ¸·Î ÇÏ´Ï Àß µË´Ï´Ù. ¤Ð¤Ð
Sub PrintAll_Click()
Dim i As Integer
Dim CntA As Integer
CntA = Application.WorksheetFunction.CountA(Range("B2:B100"))
For i = 0 To CntA
Sheets("print").Cells(1, 1) = Sheets("print_list").Cells(1 + i, 2)
Sheets("print").PrintOut
Next i
End Sub
Áú¹®Àº ÁÁÀº°Å³×¿ä... Áú¹®ÇÏ´Ùº¸´Ï ½º½º·Î Ç®¸®´Â ¹®Á¦°¡ ÀÖ³×¿ä ¤Ð
Áú¹® | 1268¸íÀÌ Àоú¾î¿ä. 3.134.102.182