| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Macro to take me to a different tab to specific cell
I need to create a Macro to take me to a different tab with a specific cell
within that tab being at the top left hand corner. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Macro to take me to a different tab to specific cell
Sub Macro1()
Application.Goto Reference:=Worksheets("Sheet3").Range("Z100"), scroll:=True End Sub -- Gary''s Student - gsnu200784 "Don Lowe" wrote: I need to create a Macro to take me to a different tab with a specific cell within that tab being at the top left hand corner. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Macro to take me to a different tab to specific cell
Thank you - That worked great!
"Gary''s Student" wrote: Sub Macro1() Application.Goto Reference:=Worksheets("Sheet3").Range("Z100"), scroll:=True End Sub -- Gary''s Student - gsnu200784 "Don Lowe" wrote: I need to create a Macro to take me to a different tab with a specific cell within that tab being at the top left hand corner. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro from cell specific to whole column | Excel Discussion (Misc queries) | |||
| How to pick a specific cell within a macro .... ?? | Excel Discussion (Misc queries) | |||
| Opening at specific cell - No Macro | Excel Discussion (Misc queries) | |||
| Goto a specific cell in a macro | Excel Discussion (Misc queries) | |||
| How do I run a Macro on basic of a value in a specific cell | Excel Worksheet Functions | |||
![Don Lowe[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
