Рейтинг:  0 / 5

Звезда не активнаЗвезда не активнаЗвезда не активнаЗвезда не активнаЗвезда не активна
 

Sub Add_pictures()
Set CurrentWorkbook = Workbooks(ActiveWorkbook.Name)
Set InputWorksheet = CurrentWorkbook.Sheets("BASE")
Set OutputWorksheet = CurrentWorkbook.Sheets("meBOM - OTH&HH")
Dim sh As Shape
Dim i As Integer
InputWorksheet.Select

Set rng = InputWorksheet.Range(Cells(3, 1), Cells(172, 1))

For Each cell In rng
'Delete
'For Each sh In OutputWorksheet.Shapes
' If sh.TopLeftCell.Address = OutputWorksheet.Cells(cell.Row, 23).Address Then sh.Delete
'Next
For i = 1 To 172
If (cell.Value = OutputWorksheet.Cells(i, 1).Value) Then
InputWorksheet.Cells(cell.Row, 18).Copy Destination:=OutputWorksheet.Cells(i, 23)
End If
Next i
Next cell

End Sub