Excel has a MOD function that returns the remainder after a division. Excel VBA also has the Mod operator. Unfortunately, they return different results when it comes to negatives.
Monthly Archives: March 2024
What matters in life is not what happens to you but what you remember and how you remember it.
Writer and Nobel Prize winner Gabriel García Márquez
Does an Excel range contain sequential numbers?
I have created a custom function to check if a range has sequential numbers. The range doesn’t have to be sorted.
I have long understood that climate change is not only an environmental issue – it is a humanitarian, economic, health, and justice issue as well.
Environmental activist, Frances Beinecke
Excel VBA and the # Symbol
The # symbol is used in Excel sheets for hyperlinks and dynamic arrays. It is also used in VBA for date definitions.
Colour Constants Updated
Thanks to Rick Rothstein MVP for sharing a LinkedIn article he wrote a while back about colour constants. He gave me permission to share the contents in this post. Making your own colour constants.
VBA Color Constants
Simplify using basic colours
In Excel colours are colors. If you want to used basic colours you can use the built-in VBA color constants. This simplifies the code and makes it more descriptive.
Be prepared to appreciate what you meet.
A Fremen proverb from Dune by Frank Herbert.