User Tools

Site Tools


microsoft_excel:macros:scroll_to

Differences

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

Link to this comparison view

microsoft_excel:macros:scroll_to [2021/08/04 14:24] – created petermicrosoft_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 "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/macros/scroll_to.1628087071.txt.gz · Last modified: 2021/08/04 14:24 by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki