Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » VBA hints and tips » Use GoTo to Select A Cell With VBA
Use GoTo to Select A Cell With VBA
To select a certain cell on a Worksheet you can use:
Application.Goto Reference:=Range("V300")
or more simply
Range("V300").Select
If, on the other hand, you want the selected cell to be the top/left cell on the screen you use:
Application.Goto Reference:=Range("V300"), Scroll=True
Added by Carlos on 24th November 2006
More VBA hints and tips, like:
- Empty The Clipboard with CutCopyMode
- Count the Rows and Columns in a Selection
- Use VbNullString instead of
 |
|
» Forum post: Relative and absolute referencing |
Could you , in simple terms, explain these two processes
