VBA lacks a keyboard shortcut for commenting. This is a standard feature in modern IDEs, however, the VBA Editor is not modern, so we are forced to tolerate its drawbacks. Comments are denoted using a single quotation mark (‘). Block…
Press Shift + Ctrl + A after a function to display all its arguments. Then put a leading single quote to signify text. I often find this useful if I need to retrieve the arguments of a function I’m explaining….
Wednesday’s announcement of 14 new Excel functions was welcoming news. However, despite switching to the BETA Channel yesterday, I am not one of the lucky ones who have access to the new batch yet. Nevertheless, I was particularly drawn to…
Calendars are useful for scheduling events, constructing to-do lists, and managing projects. Many applications exist for mobile and desktop, such as Outlook, iCloud Calendar, and Google Calendar. Whilst these are feature-packed and great for day-to-day use, nothing beats an Excel…
If you have a set of dates, you might also want their week numbers. These can be returned using the WEEKNUM or ISOWEEKNUM functions. What is the difference though? Function Syntaxes • serial_number — a valid date in serial number…
End of content
End of content
