<p>Sub 工资条()<br/>Dim I As Integer<br/>For I = 9 To 3 Step -1<br/>Rows(I).Insert<br/>Rows(I) = Rows(1).Value<br/>Next I<br/>End Sub</p><p>Sub 恢复()<br/>Dim I As Integer<br/>For I = 2 To 30<br/>If Range("a" & I) = "姓名" Then<br/>Rows(I).Delete<br/>End If<br/>Next I<br/>End Sub</p><p><br/>Sub 恢复1()<br/>Dim K As Integer<br/>For K = 15 To 3 Step -2<br/> Rows(K).Delete<br/> Next K<br/>End Sub<br/></p><p>后两个恢复都可行,但倒着来简单,正着做,好理解,呵呵,各有千秋,请老师阅批,我提个建议,如果是简单的代码,学员直接发代码老师看起来更省事些,不用再下载,下载很费时间,另还要再删除,很麻烦。</p>
[此贴子已经被作者于2007-11-24 23:00:57编辑过] |