Being able to comment a block of code is a standard operation in any IDE, but for some reason the Microsoft Office VBA Editor does not include that functionality by default. However, the functionality is there and waiting to be used, it’s just hidden in the “Edit” toolbar which is not visible be default. Open Read More
Month: June 2021
How to Fix “Procedure Too Large” Error in Excel VBA
You probably have one or more gigantic procedures/functions and I think VBA has a limit of 64k or something per procedure. You fix it by splitting that procedure up into multiple procedures that can then be called by the one procedure. So instead of having: You’d have something like:
Cell Phone Coverage in Canada: Who is The Best
Stop trusting carrier coverage maps and find out which networks offer the best coverage from those using them everyday By: JON STONE Having access to all the features of a modern smartphone is amazing — until you don’t have a signal or Wi-Fi available. This makes coverage an essential element in choosing the best cell phone Read More
How to Fix Missing Personal Hotspot on iPhone
The iPhone Personal Hotspot feature transforms your phone into a Wi-Fi hotspot that can share its internet connection with other nearby devices. However, that can’t happen if Personal Hotspot is missing. The information in this article applies to iPhones running iOS 12 and up. The basic ideas work for earlier versions of iOS, as well. Read More
Understand the Difference Between Calculated Columns and Measures in Power BI
Calculated Columns and Measures in DAX. One of the first concepts to learn in DAX is the difference between calculated columns and measures. This article shortly recaps the differences and describes when to use each one. Calculated columns When you create a data model in Power Pivot for Excel, Analysis Services Tabular, or Power BI Read More
My Son’s Math Challenge – From a Grade 2 Student.
Please see the solutions here: https://summalai.com/?p=3429