|
初学者,业余水平.请多指教.非常谢谢!!!
Option Explicit
Sub 第一题()
Dim x As Integer
For x = 3 To 10
If Cells(x, 2) > 0 Or Range("b" & x).End(xlToRight) > 0 Then
Cells(x, 1) = "1"
Else
Cells(x, 1) = ""
End If
Next x
End Sub
Sub 第二题()
Dim wb As Workbook
Dim sh As Worksheet
Dim rg As Range
Dim rg1 As Range
Dim x As Integer
Set wb = Workbooks.Open(ThisWorkbook.Path & "\A.xls")
For x = 1 To Worksheets.Count
Set rg = wb.Sheets(x).UsedRange
Set rg1 = ThisWorkbook.Sheets("第2题").Range("a65536").End(xlUp).Offset(1, 0)
rg.Copy rg1
Next x
wb.Close True
End Sub
|
|