My Downloads and why I like New Book Navigator

I have a few add-ins and files for download on my site, one of which I have recently been working quite a bit.

It’s my New Book Navigator addin and like the name says it helps you navigate around a workbook, as well as select, deselect and highlight cells.

The “New” part is to distinguish it from the previous version. Anyway, it’s evolved into a pretty good add-in over time (my opinion) and it does a lot of things you might find come in handy.

One of those things is what I call Quick Filter. It’s not a filter in the ordinary sense but unlike Excel’s inbuilt filters, it allows you to find and go to cells in both rows or columns, you can even use it to go to hidden cells without the need to unhide them.

Another thing is that you can see what range is selected at any time and copy that range if desired to the clipboard. The range details can also changed to show as Absolute or Relative, A1 or R1C1 references. The default setting is to update the toolbar as you select ranges automatically but you set this to Manual in the Options settings if you want to avoid the screen from flickering when running code. Details of this and all of the other features are described in both the read me files and Help files.

My download page is here. I hope you find New Book Navigator and my other stuff useful.