microsoft_excel:macro_scroll_to
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
microsoft_excel:macro_scroll_to [2016/07/11 11:28] – created peter | 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.1468236506.txt.gz · Last modified: 2020/07/15 09:30 (external edit)