A = Range("a1").CurrentRegion
For i = 2 To UBound(A)
For j = 5 To UBound(A, 2)
If A(i, j) = "" Then
If rng Is Nothing Then
Set rng = Cells(i - 1, j)
Else
Set rng = Application.Union(rng, Cells(i - 1, j))
End If
End If
Next j
Next i
rng.Select
End Sub
A = Range("a1").CurrentRegion
For i = 2 To UBound(A)
For j = 5 To UBound(A, 2)
If A(i, j) = "" Then
If rng Is Nothing Then
Set rng = Cells(i - 1, j)
Else
Set rng = Application.Union(rng, Cells(i - 1, j))
End If
End If
Next j
Next i
rng.Select
End Sub