bookmark or hyperlink?

S

swissforestry

Is there a way to create a "button" in a worksheet that will take you to
a specific place somewere else in a worksheet?

As a way to not have to scroll through a large workbook.
 
K

Kevin B

You can name the cell by clicking INSERT on the menu and selecting NAME,
DEFINE.

After the name has been defined you can press the F5 GoTo key, which will
display a list of named cells in the workbook. You can either select the
name from the list of displayed names or type the name yourself in the
REFERENCE field. Click OK and you're there.
 
C

Chip Pearson

Create a button on the worksheet and assign the following macro
to it:

Sub GotoRange()
Application.Goto Worksheet("Sheet2").Range("A2"),True
End Sub

change the range as desired.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"swissforestry"
in message
news:[email protected]...
 
Top