<p><font size="2">Sub add1( )<br/>Dim x, y<br/> If [I4] = "" Then<br/> MsgBox "姓名不能为空!"<br/> Else<br/> x = [A65536].End(xlUp).Row + 1<br/> For y = 1 To 4<br/> Cells(x, y) = Cells(y * 2 + 2, "I")<br/> Next<br/> End If<br/>End Sub<br/>+1</font></p><p> </p>
[此贴子已经被laosanjie于2008-6-20 10:34:50编辑过] |