Home Forums Job & Work Life Visual Basic 코딩 질문 Visual Basic 코딩 질문 Name * Password * Email 엑셀에서 Alt+F11 에서 모듈 삽입후 아래 붙여 넣으시고 실행 하십시요. Option Explicit Public Sub extraftCol() Dim range1 As Range Dim newworkbook As Workbook Dim newworksheet1 As Worksheet Dim newworksheet2 As Worksheet Dim rngTemp As Range Dim intCol As Integer Dim intRow As Integer 'Set range1 = Range("A:D, BI:BI,BQ:BQ") Set range1 = ActiveSheet.UsedRange Set newworkbook = Workbooks.Add Set newworksheet1 = newworkbook.Worksheets(1) Set newworksheet2 = newworkbook.Worksheets(2) Application.ScreenUpdating = False For Each rngTemp In range1 If Not IsEmpty(rngTemp) Then intCol = rngTemp.Column intRow = rngTemp.Row Select Case intCol Case 1 newworksheet1.Cells(intRow, 1) = rngTemp newworksheet2.Cells(intRow, 1) = rngTemp Case 2 newworksheet1.Cells(intRow, 5) = rngTemp newworksheet2.Cells(intRow, 7) = rngTemp Case 3 newworksheet1.Cells(intRow, 4) = rngTemp newworksheet2.Cells(intRow, 6) = rngTemp Case 4 newworksheet1.Cells(intRow, 3) = rngTemp newworksheet2.Cells(intRow, 4) = rngTemp Case 61 newworksheet1.Cells(intRow, 2) = rngTemp newworksheet2.Cells(intRow, 3) = rngTemp Case 69 newworksheet1.Cells(intRow, 6) = rngTemp newworksheet2.Cells(intRow, 9) = rngTemp Case Else End Select End If Next Application.ScreenUpdating = True End Sub I agree to the terms of service Comment