Выбираем область Rows("1:150").Select ' Копируем Selection.Copy ' Открываем книгу отдела Workbooks.Open Filename:="\\srv\Obmen\_ФОРМЫ\АРХИВ\" & Range("C5").Value & ".xlsx" ' Снимаем защиту ActiveSheet.Unprotect Password:="*******"' Вставляем скопированное в первую пустую строку Dim emptyRow As Long emptyRow = WorksheetFunction.CountA(Range("B:B")) + 1 Cells(emptyRow, 1).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Cells(emptyRow, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Cells(emptyRow, 1).PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Cells(emptyRow, 1).PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Sub Пример() Dim wsAct As Worksheet Set wsAct = ActiveSheet Workbooks.Open Filename:="c:\" & Range("a3").Value & ".xlsx" ActiveSheet.Unprotect Password:="1111" Dim emptyRow As Long emptyRow = WorksheetFunction.CountA(Range("B:B")) + 1 wsAct.Rows("10:18").Copy Cells(emptyRow, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Cells(emptyRow, 1).PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Cells(emptyRow, 1).PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, SkipBlanks:=False, Transpose:=FalseEnd Sub
Selection.AutoFilter ActiveSheet.Range("$B:$B").AutoFilter Field:=1, Criteria1:="="Cells.Delete