第一题:
Sub text1()
Dim rg As Range
Set rg = Columns("b:d").SpecialCells(xlCellTypeConstants).EntireRow
Intersect(Columns("a:a"), rg) = 1
End Sub
第二题:
Sub t2()
Dim wb As Workbook, x As Integer
Set wb = Workbooks.Open(ThisWorkbook.Path & "\A.xls")
For x = 1 To Sheets.Count
If x = 1 Then
wb.Sheets(x).UsedRange.Copy ThisWorkbook.Sheets("第2题").Range("a1")
Else
wb.Sheets(x).UsedRange.Offset(1, 0).Copy ThisWorkbook.Sheets("第2题").Range("a65536").End(xlUp).Offset(1, 0)
End If
Next x
wb.Close False
End Sub