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