PC Review


Reply
Thread Tools Rate Thread

Bookmarks in Excel???

 
 
Phil
Guest
Posts: n/a
 
      6th Mar 2008
I am new to Excel programming, but am very familiar with Word. In Word, you
can search for a particular location in a document using the Bookmark
function. Is there a similar option in Excel? If so, how do you create it
and search for it.

Thanks,

Phil
 
Reply With Quote
 
 
 
 
Jim Rech
Guest
Posts: n/a
 
      6th Mar 2008
To ease navigating you can name a cell or range using Ctrl-F3 and then
return to it using F5.

--
Jim
"Phil" <(E-Mail Removed)> wrote in message
news:81139E54-96B0-4741-BE2D-(E-Mail Removed)...
|I am new to Excel programming, but am very familiar with Word. In Word,
you
| can search for a particular location in a document using the Bookmark
| function. Is there a similar option in Excel? If so, how do you create
it
| and search for it.
|
| Thanks,
|
| Phil


 
Reply With Quote
 
Jim Thomlinson
Guest
Posts: n/a
 
      6th Mar 2008
There aren't really anything analagous to bookmarks. What you could use would
be named ranges. Create the named range by selecting the cell or cells that
you want to navigate to and in the Address Box change the address to some
name. Now when you want to go to that area just select the name from the
address drop down...
--
HTH...

Jim Thomlinson


"Phil" wrote:

> I am new to Excel programming, but am very familiar with Word. In Word, you
> can search for a particular location in a document using the Bookmark
> function. Is there a similar option in Excel? If so, how do you create it
> and search for it.
>
> Thanks,
>
> Phil

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA help window: Multiple windows/tabs, bookmarks, bookmarks/historypane paul.domaskis@gmail.com Microsoft Outlook VBA Programming 4 19th May 2009 02:09 PM
Bookmarks in Excel??? Phil Microsoft Excel Worksheet Functions 2 6th Mar 2008 04:29 PM
Export From Bookmarks To Excel SJ Carter Microsoft Excel Programming 1 25th Jul 2007 09:19 PM
Word 2007 bookmarks - How to display bookmarks on page? =?Utf-8?B?cmdpbGxl?= Microsoft Word Document Management 1 21st Apr 2007 10:06 PM
bookmarks in excel Rightmer Microsoft Excel Setup 1 28th Jan 2004 02:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:27 AM.