ExcelBanter - Go To a Named Range

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Go To a Named Range (https://www.excelbanter.com/excel-worksheet-functions/448099-go-named-range.html)

Go To a Named Range

When I go to a Named Range, how is it possible that the Named Range will be positioned at cell A1.

Thanks

Paga Mike

Quote:

Originally Posted by (Post 1609041)

When I go to a Named Range, how is it possible that the Named Range will be positioned at cell A1.

Thanks

Easy with a macro:

Sub Macro1()
Application.Goto Reference:="alpha", Scroll:=True
End Sub

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