First and Last Cell Address in a Range
Following on from my last two VBA posts here is how you can identify the cell addresses of the first and last cells in a range.
(more…)Free Excel Webinar Recording – Mouse Shortcuts
When I ran some face to face training sessions recently I was reminded how much people LOVE shortcuts. I did a keyboard shortcut webinar session in October 2018. In November 2018 I shared lots of mouse shortcuts. Download the materials using the button below and watch the video. CPD note - if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances. [button…
VBA to Find the Row and Column Number Limits of a Range
In my last blog post I found the last used row and column numbers on the active sheet. This post lets us find the row and column extremities of a specific range.
(more…)Bold Your Headings
Apparently this is not widely known, but you should always bold the headings in your tables. Then when you use Format as Table (Ctrl + t) on the Home ribbon tab the header row will be correctly identified. This also applies to the Ctrl + Shift + L shortcut to insert the filter drop downs. It also applies to the ranges used for charts. In general ALWAYS BOLD your headings - it is something Excel looks for. Ctrl + b…
Excel VBA to Find the Last Used Row or Column
When writing VBA code it is common to need to know the last used row and/or the last used column. These values provide the edges of the sheet contents.
(more…)Controlling a Conditional Format with a Checkbox
Here is a technique that allows you to turn off and turn on the conditional format without actually removing the conditional format. You may want to do this to print a sheet without the conditional formats being applied. (more…)