microsoft_excel:macros:scroll_to
Differences
This shows you the differences between two versions of the page.
microsoft_excel:macros:scroll_to [2021/08/04 14:24] – created peter | microsoft_excel:macros:scroll_to [2021/08/04 15:10] (current) – removed peter | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Excel - Macros - 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/macros/scroll_to.1628087071.txt.gz · Last modified: 2021/08/04 14:24 by peter