سرچی که توی نت کردم .. روش دیگر استفاده از این ماکرو VBA for inverting selections هست
<em>Sub InvertSelection()
'Updateby20140314
Dim rng As Range
Dim Rng1 As Range
Dim Rng2 As Range
Dim OutRng As Range
xTitleId = "KutoolsforExcel"
Set Rng1 = Application.Selection
Set Rng1 = Application.InputBox("Range1 :", xTitleId, Rng1.Address, Type:=8)
Set Rng2 = Application.InputBox("Range2", xTitleId, Type:=8)
For Each rng In Rng2
If Application.Intersect(rng, Rng1) Is Nothing Then
If OutRng Is Nothing Then
Set OutRng = rng
Else
Set OutRng = Application.Union(OutRng, rng)
End If
End If
Next
OutRng.Select
End Sub<em><span style="background-color: #ccffcc;"></span></em>
</em>

سئوال من اینه که در محدوه range1 و rang2 مثلا برای همون 300 رکورد چه باید قرار داد ؟ و آیا اصلا این ماکرو برای reverse کردن جواب میدهد ؟