The process you describes makes 50 copies of I6:W6, as does this[VBA]Dim i As Long
With Range("I6:W6")
For i = 1 to 50
.Offset(25*i,0).Value = .Value
Next i
End With[/VBA]
The process you describes makes 50 copies of I6:W6, as does this[VBA]Dim i As Long
With Range("I6:W6")
For i = 1 to 50
.Offset(25*i,0).Value = .Value
Next i
End With[/VBA]
Posting Permissions
Reply With Quote