|
- Sub 按钮1_Click()
- Dim row&, Row1&
- Row1 = Sheet7.Cells(Rows.Count, 3).End(3).row
- With Sheet1
- row = .Cells(Rows.Count, 2).End(3).row
- .Cells(1, 3).Resize(row, 1).Value = "=IFERROR(VLOOKUP(B1,整理!C2:AN&""" & Row1 & """,38,FALSE),B1)"
- .Cells(1, 3).Resize(row, 1).Value = .Cells(1, 3).Resize(row, 1).Value
- End With
- End Sub
本帖最后由 lisachen 于 2012-4-13 23:18 编辑
- Sub 按钮1_Click()
- Dim row&, Row1&
- Row1 = Sheet7.Cells(Rows.Count, 3).End(3).row
- With Sheet1
- row = .Cells(Rows.Count, 2).End(3).row
- .Cells(1, 3).Resize(row, 1).Value = "=IFERROR(VLOOKUP(B1,整理!C$2:AN" & Row1 & ",38,FALSE),B1)"
- .Cells(1, 3).Resize(row, 1).Value = .Cells(1, 3).Resize(row, 1).Value
- End With
- End Sub
复制代码
|
|