Hello everyone. Can someone explain to me why the following code doesn't work properly?
For Each ws2 In Worksheets
If ws2.Name <> "Sheet1" And ws2.Name <> "Sheet2" Then
For i = 12 To 15
Sheets("Sheet1").Cells(i, 6).Copy
ws2.Range("I23").PasteSpecial xlPasteAll
Next i
Application.CutCopyMode = False
End If
Next ws2
What I want to do is the following: I have multiple sheets and with the first for loop I want to go through each sheet starting from sheet3.By using the second for loop i want everytime to copy the values from Sheet1 starting at 12 row and 6th column up to 15 row and 6th column and afterwards paste these values to each sheet at a specific range(I23). My problem is that the result of this code is, that it always pastes only the value which corresponds to i =15.
Thank you for your help
Bookmarks