Sub test()
Dim Rng As Range
Dim ChangeRng As Range
Dim Rnum As Integer
Dim Cnum As Integer
Dim I As Integer
Dim J As Integer
Set Rng = Sheet1.Range("d8:h12")
Rnum = Rng.Rows.Count
Cnum = Rng.Columns.Count
Set ChangeRng = Sheet1.Range("j8").Resize(Rnum, Cnum)
Do
With ChangeRng
.Cells(1, 1) = Rng.Cells(1, 1)
.Cells(1, Cnum) = Rng.Cells(1, Cnum)
.Cells(Rnum, 1) = Rng.Cells(Rnum, 1)
.Cells(Rnum, Cnum) = Rng.Cells(Rnum, Cnum)
If Rnum = 1 Then
.Cells(Rnum, Cnum) = Rng.Cells(Rnum, Cnum)
Exit Sub
End If
Rnum = Rnum - 2
Cnum = Cnum - 2
Set Rng = Rng.Offset(1, 1).Resize(Rnum, Cnum)
Set ChangeRng = ChangeRng.Offset(1, 1).Resize(Rnum, Cnum)
End With
Loop
End Sub
|