且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

选择页面的最后一行

更新时间:2023-02-05 09:50:37

For example:

Sub HighlightLast()
    Dim r As Long
    Dim m As Long
    Application.ScreenUpdating = False
    m = Cells.Find(What:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
    For r = 21 To m Step 20
        Range("A" & r).Resize(1, 3).Interior.Color = vbYellow
    Next r
    ' Last row
    If m Mod 20 <> 1 Then
        Range("A" & m).Resize(1, 3).Interior.Color = vbYellow
    End If
    Application.ScreenUpdating = True
End Sub


相关阅读

技术问答最新文章