ExcelBanter - Need Macro to take me to a different tab to specific cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Need Macro to take me to a different tab to specific cell (https://www.excelbanter.com/excel-programming/410479-need-macro-take-me-different-tab-specific-cell.html)

Don Lowe[_2_]

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.

Gary''s Student

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.

Don Lowe

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.

All times are GMT +1. The time now is 10:59 PM.