ee = Sheets("意向金台账").Range("B65536").End(xlUp).Row
For ff = 3 To ee
If Sheets("意向金台账").Range("k" & ff) <> "" Then
Sheets("意向金台账").Range("k" & ff).EntireRow.Select
End If
Next ff
sub t()
Dim ee As Integer
Dim ff As Integer
Dim rSelect as Range
ee = Sheets("意向金台账").Range("B65536").End(xlUp).Row
For ff = 3 To ee
If Sheets("意向金台账").Range("k" & ff) <> "" Then
If rSelect Is Nothing Then
Set rSelect = Sheets("意向金台账").Rows(ff)
Else
Set rSelect = Union(rSelect, Sheets("意向金台账").Rows(ff))
End If
End If
Next ff
rSelect.Select
End Sub
sub t()
Dim ee As Integer
Dim ff As Integer
Dim rSelect as Range
ee = Sheets("意向金台账").Range("B65536").End(xlUp).Row
For ff = 3 To ee
If Sheets("意向金台账").Range("k" & ff) <> "" Then
If rSelect Is Nothing Then
Set rSelect = Sheets("意向金台账").Rows(ff)
Else
Set rSelect = Union(rSelect, Sheets("意向金台账").Rows(ff))
End If
End If
Next ff
rSelect.Select
End Sub