Range Navigator – Smarter Navigation for Excel


My previous Excel Navigation add-in fetched a few fans; I got a lot of positive feedback on LinkedIn. I designed it to help people working on enormous spreadsheets. I then realized that big workbooks usually host many sheets. I received a few requests to add worksheet selection functionality into the form. Nothing makes me happier than to help my fellow strugglers, so I worked on an extension.

Range Navigator

So here is what you can do with this little bad-boy:

  1.  ‘Scroll’ through all the workbooks open in the current instance of Excel, by clicking and dragging through the listbox
  2.  ‘Scroll’ through all the visible worksheet in each workbook.
  3. Then you can use the ‘Nav Pad’ to scroll through the sheet’s used range
  4. If you press the little toggle button at the bottom, the form becomes a little bigger and reveals two more list boxes. One for all the global range names in the workbook, and another for the local names in the selected worksheet.
  5. Now, the ‘Nav Pad’ scrolls through the selected range name only.

 

Range Navigator

Download RangeNav V1.01.xla  from Dropbox. I have not fully tested it yet. I expect some errors: protected workbooks, protected worksheets, non-rectangular ranges, etc. Do let me know if any errors pop up.

Advertisements

3 thoughts on “Range Navigator – Smarter Navigation for Excel

  1. Pingback: Initialize Local Range Names in VBA Quicker | Struggling To Excel

  2. Pingback: Initialize Local Range Names in VBA Quicker | Struggling To Excel

If you liked it, let me know. If you didn't make sure you let me know!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s