Monthly Archives: Feb 2023

VBA Application methods compatibility in Excel and Access

When working on VBA code that should work in both MSExcel and MSAccess VBA, the different application object methods can be hard to manage. For example, Application.Screenupdating = False is used in Excel but would raise a compile error in … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

Excel formula to test if a word contains certain letters

Victor Momoh in the Global Excel Summit, to start a discussion on readability, provocatively used MMULT in a formula to determine whether a word contains all five vowels.  As Victor said, in real life he’d use a simple SUM:=SUM(1*ISNUMBER(SEARCH(MID(“aeiou”,SEQUENCE(1,5),1),A2))) SEQUENCE generates … Continue reading

Posted in Excel/VBA | 7 Comments