Daily Dose of Excel

I have these four favorites defined in Outlook: From the inbox, I could hit Shift+F6 to get into the Favorites area but sometimes I would end up in no man’s land and couldn’t figure out how t...

http://dailydoseofexcel.com/archives/2023/03/23/navigating-outlook-favorites/

In response to https://nolongerset.com/all-about-indenting/

http://dailydoseofexcel.com/archives/2023/01/11/autohotkey-in-vba/

I have a fairly slow running macro (~20 seconds) that works fine on one computer, but never finishes on another. If finally decided to figure out why. (Big Daddy is the nickname of the guy who st...

http://dailydoseofexcel.com/archives/2021/05/30/macros-with-32-bit-api-calls/

Do you use Range names in Excel? Today I have updated my 100% free Excel Name Manager add-in with two new features: – Edit the name’s comment – Filter Lambda names https://jkp-ads.com/offic...

http://dailydoseofexcel.com/archives/2020/12/14/name-manager-updated-2/

Hi There, It’s been a while since I last posted here. Today I have released an update of my RefTreeAnalyser utility. The tool now allows you to add a Table Of Contents to your workbook which co...

http://dailydoseofexcel.com/archives/2020/12/04/reftreeanalyser-two-updates/

In Excel 2019 16.0.10361.20002 32-bit, when I open a file from a userform (which for me is always), the hotkeys on the Ribbon don’t work. Here’s how I reproduce: In a new workbook, add a user...

http://dailydoseofexcel.com/archives/2020/09/09/opening-a-file-from-a-userform-disables-ribbon/

https://excelvirtuallyglobal.com/ Tue 21 July to Thu 23 July 2020 Microsoft’s Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the commun...

http://dailydoseofexcel.com/archives/2020/07/17/excel-virtually-global/

Hi there. Hope you and yours are well in these difficult times! This is just a very short announcement that I’ll be doing an on-line version of my Excel VBA Masterclass. The training is schedul...

http://dailydoseofexcel.com/archives/2020/04/27/excel-vba-masterclass/

The first Wednesday of every November is International Keyboard Shortcut Day. This Wednesday, people from all over the world will become far less efficient for a short time in an effort to be far...

http://dailydoseofexcel.com/archives/2019/11/04/international-keyboard-shortcut-day-2019/

It’s been a great competition and now it is time to announce the winners. Check out my new Excel challenges page to find out which solutions I received and who won the prize for best solution! ...

http://dailydoseofexcel.com/archives/2019/09/19/combinations-combinations-and-the-winner-is/