bookmark or hyperlink?
 

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.


--
swissforestry
------------------------------------------------------------------------
swissforestry's Profile: http://www.excelforum.com/member.php...o&userid=28719
View this thread: http://www.excelforum.com/showthread...hreadid=515388

bookmark or hyperlink?
 

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.
--
Kevin Backmann


"swissforestry" wrote:


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.


--
swissforestry
------------------------------------------------------------------------
swissforestry's Profile: http://www.excelforum.com/member.php...o&userid=28719
View this thread: http://www.excelforum.com/showthread...hreadid=515388

bookmark or hyperlink?
 

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"
wrote
in message
news:swissforestry.23n3cn_1140626410.038@excelforu m-nospam.com...

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.


--
swissforestry
------------------------------------------------------------------------
swissforestry's Profile:
http://www.excelforum.com/member.php...o&userid=28719
View this thread:
http://www.excelforum.com/showthread...hreadid=515388