Visual Basic 코딩 질문

Ladybug 75.***.139.141

엑셀에서 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