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.
Andrew, this is nice upgrade to your add-in!
However, you might want to look at the code for the “Select To Far Right Column” button, when I push the button it selects to the left.
Hi Blayne,
That might be because the default works with the used range of a sheet – if you have a blank sheet, it will select to the first column, or if you are selecting cells to the right of a used range, it will select to the left. It depends where the cursor is and where the used range is.
If the Ctrl key is pushed, you can select until the extents of the sheet no matter where the cursor is. In this respect, it might be more useful than using the Ctrl and arrow key combination depending on what you want to do. I will add this second part to the Help files, I must have forgotten with the recent upgrade :-)
Andrew
The revised Help file has been uploaded.