Копирование только нужного диапазона в Microsoft Office Excel

Function WorksheetExists(shtName As String, Optional wb As Workbook) As Boolean
    Dim sht As Worksheet

     If wb Is Nothing Then Set wb = ThisWorkbook
     On Error Resume Next
     Set sht = wb.Sheets(shtName)
     On Error GoTo 0
     WorksheetExists = Not sht Is Nothing
 End Function


Sub GoBitch()
    Dim i As Integer
    Dim r As Integer
    Dim sh As Worksheet
    Set sh = Nothing
    
    For i = 3 To 18
        If Cells(i, "A") = vbNullString Then Exit For
        If Cells(i, "A").MergeCells Then
          if not WorksheetExists(cells(i,"A")) then
        Set sh = Sheets.Add(After:=Sheets(Sheets.Count))
        sh.Name = Cells(i, "A")
          else
              set sh = sheets(cells(i,"A").value)
          end if
         r = sh.cells(sh.rows.count,"A").end(xlup).row + 1
        Else
            If Not sh Is Nothing Then
                sh.Cells(r, "A") = Cells(i, "A")
                sh.Cells(r, "B") = Cells(i, "B")
                sh.Cells(r, "C") = Cells(i, "C")
                r = r + 1
            End If
        End If
    Next i
End Sub