第1个回答 推荐于2017-05-22
Sub aa()
For j = 1 To Worksheets.Count
With Worksheets(j)
For i = 3 To 32
If .Cells(i, 7).Value = "" Then 'i代表行,1代表列
.Cells(i, 7).Value = .Cells(i, 6).Value
End If
Next
End With
Next
End Sub本回答被网友采纳
第2个回答 2015-09-18
Sub aa()
Dim Sh As Worksheet
For Each Sh In Worksheets
For i = 3 To 32
If Sh.Cells(i, 7).Value = "" Then 'i代表行,1代表列
Sh.Cells(i, 7).Value = Sh.Cells(i, 6).Value
End If
Next i
Next
End Sub
第3个回答 2015-09-18
要在每个表格的VBA中worksheet方法中调用该过程 语句为CALL aa();
但调用肯定您在什么条件下进行调用,要选择合适的worksheet的方法。