User Tools

Site Tools


microsoft_excel:macro_scroll_to

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
microsoft_excel:macro_scroll_to [2020/07/15 09:30] – external edit 127.0.0.1microsoft_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 "sheet22", "A1" 
-Sub ScrollTo(ws As String, rng As String) 
- 
-    Application.GoTo Worksheets(ws).Range(rng), True 
-    Worksheets(ws).Range(rng).Select 
- 
-End Sub 
-</code> 
  
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