User Tools

Site Tools


microsoft_excel:macro_scroll_to

This is an old revision of the document!


Excel - Macro Scroll To

' Scrolls the worksheet to the specific range.
' For instance ScrollTo "sheet22", "A1"
Sub ScrollTo(ws As String, rng As String)
 
    Application.GoTo Worksheets(ws).Range(rng), True
    Worksheets(ws).Range(rng).Select
 
End Sub
microsoft_excel/macro_scroll_to.1594805433.txt.gz · Last modified: 2020/07/15 09:30 by 127.0.0.1

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki