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.
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.
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
>
>
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"
<[email protected]> wrote
in message
news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks