|
水月芽 发表于 2014-3-11 09:17
非常感谢妙妙的帮忙!!
但运行中发现两个问题:1、同名同姓会出错,我后加括号,能克服;2、表中的数据无 ... - Sub 个税申报()
- Dim Arr, i%
- On Error Resume Next
- Arr = Sheets(1).Range("a1").CurrentRegion.Value
- Application.ScreenUpdating = False
- For i = 2 To UBound(Arr)
- Sheets("申报表").Copy after:=Sheets(Sheets.Count)
- With Sheets(Sheets.Count)
- .Name = Arr(i, 3)
- If Err.Number <> 0 Then .Name = Arr(i, 3) & i
- .[b5] = Arr(i, 3)
- .[i5] = Arr(i, 4)
- .[c11] = Arr(i, 5)
- .[f11] = Arr(i, 6)
- .[g11] = Arr(i, 7)
- .[h11] = Arr(i, 8)
- .[g11] = Arr(i, 10)
- End With
- Next
- End Sub
复制代码 |
|