Sub t1()
Range("B:D").SpecialCells(xlCellTypeConstants).Select
Range("B:D").SpecialCells(xlCellTypeConstants).Value = "1"
End Sub
Sub t2()
Dim wb1 As Workbook, wb2 As Workbook, i As Integer, x As Integer, y As Integer
Set wb = ThisWorkbook
For x = 1 To Windows.Count
If Windows(x).Caption = "A.xls" Then
Exit For
End If
If x = Windows.Count Then
Set wb2 = Workbooks.Open(ThisWorkbook.Path & "\A.xls")
End If
Next x
For i = 1 To Workbooks("A.xls").Sheets.Count
If i = 1 Then
Workbooks("A.xls").Sheets(i).UsedRange.Copy wb.Sheets("sheet1").Range("A1")
Else
y = Range("a65536").End(xlUp).Row + 1
Workbooks("A.xls").Sheets(i).UsedRange.Copy wb.Sheets("sheet1").Range("A" & y)
wb.Sheets("sheet1").Rows(y).Delete
End If
Next i
End Sub