Excel VBA to Navigate to Sheets
If you right click the arrows on the left of the sheet tabs at the bottom, left of the Excel screen you can see a list of all the sheets in the file. You can use VBA to show this list anywhere.
(more…)Clear the Filter in One Column Only in Excel
When you have multiple filters across columns you may want to clear just the filter in one column. There is a keyboard technique to do that.
(more…)Selecting the Cell in the First Row in a Column in Excel
There is a keyboard shortcut to select the first column in a row, but as far as I know there is no shortcut for the first row in a column.
(more…)Dynamic Arrays and a Book Index
Years back when I wrote my Excel book, I had to create an index for the book. I shared the file I used including the macro in this post. Recently I thought dynamic arrays could do much of the work for this.
(more…)