Begin challenging your own assumptions. Your assumptions are your windows on the world. Scrub them off once in a while, or the light won’t come in.
Alan Alda – commencement speech – 1980
Monthly Archives: August 2022
Excel File is Open VBA Function
Useful function
When working with files in VBA code, you may need to know if a file is already open. A function can return TRUE if a file is currently open and FALSE if it isn’t.
A good scare is worth more than good advice.
Proverb
Excel Month on Month Movement
A PivotTable solution
If you need to find the movement from the previous month a PivotTable can be your friend and do most of the work for you.