Cloud collaboration, macro security, and new tools like Office Scripts, Power Query, and Python are pushing VBA to the margins.

Here's the problem Simplified.<P>I have a integer(x) which I need to compare against a various ranges for action. If I use regular VB, I would do something like this ...

Back in December, I wrote about Microsoft’s decision to drop support for Visual Basic for Applications (VBA) from the next version of Office. I had, and still have, many concerns about the switch. The ...