Sub demo3()
Dim i As Integer
For i = 3 To 11
If ActiveSheet.Cells(i, 9) > 0 Then
ActiveSheet.Cells(i, 10) = ""
ActiveSheet.Cells(i, 10).Interior.ColorIndex = 0
Else
ActiveSheet.Cells(i, 10) = ActiveSheet.Cells(i, 9)
ActiveSheet.Cells(i, 10).Interior.ColorIndex = 3
End If
Next
MsgBox "更新成功"
End Sub
追问这个表格我只截屏到11行,如何实现“Ctrl+shift+→ ”即最后一行非空单元格的效果呢?
追答
那就要加个判断条件
Sub demo3()
Dim i As Integer
i = 3
Do While ActiveSheet.Cells(i, 9) <> ""
If ActiveSheet.Cells(i, 9) > 0 Then
ActiveSheet.Cells(i, 10) = ""
ActiveSheet.Cells(i, 10).Interior.ColorIndex = 0
Else
ActiveSheet.Cells(i, 10) = ActiveSheet.Cells(i, 9)
ActiveSheet.Cells(i, 10).Interior.ColorIndex = 3
End If
i = i + 1
Loop
MsgBox "更新成功"
End Sub
本文如未解决您的问题请添加抖音号:51dongshi(抖音搜索懂视),直接咨询即可。