microsoft_excel:macro_scroll_to
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
microsoft_excel:macro_scroll_to [2020/07/15 09:30] – external edit 127.0.0.1 | microsoft_excel:macro_scroll_to [2021/08/04 14:24] (current) – removed peter | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Excel - Macro Scroll To ====== | ||
- | |||
- | <code excel> | ||
- | ' Scrolls the worksheet to the specific range. | ||
- | ' For instance ScrollTo " | ||
- | Sub ScrollTo(ws As String, rng As String) | ||
- | |||
- | Application.GoTo Worksheets(ws).Range(rng), | ||
- | 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