Property procedures in a standard module
I show that it is possible to declare a Property in a standard module and briefly discuss the pros and cons with doing so. This tip results from something I was doing some months ago. In the midst of coding — I’ve long since forgotten what — it struck me was that, if I were writing a class module, what I was doing was ideally suited to being made a property. So, I tried it in a standard module in Excel 2003 and, lo and behold, it worked.
Names and formatted formulas
is a draft chapter in a book. It looks at the use of names referencing references using absolute address as well as relative addresses as well named constants and formulas. Still to come is the use of names that refer to the current sheet. The draft chapter also looks at formatting a formula using line breaks and spaces, both of which are “white space” that Excel ignores. I vaguely recall from several years ago that I did something that caused Excel to collapse all the pretty formatting in a cell but I cannot recall what it was.