第一题:Sub e() Dim rg As Range
Dim rg1 As Range
Dim rg2 As Range
Set rg1 = Range("B1:D10").SpecialCells(xlCellTypeConstants).EntireRow
Set rg2 = Columns("A:A")
Set rg = Intersect(rg1, rg2)
If rg Is Nothing Then
Range("A1:A10") = ""
Else
rg = 1
End If
End Sub