by Oz du Soleil | Mar 3, 2014 | Data Integrity, Spreadsheet Development, Tips
A while ago I wrote a blogpost that attracted some hostility. One commenter even called it “stupid.” 6 Reasons Not To Use VBA (Or Be Careful) was meant to be a fun warning and an invitation to BE CAREFUL. Ah! But a few folks took it as a swearing off of...
by Oz du Soleil | Jun 6, 2012 | Excel Geekdom, Tips
Excel is already exciting, and then you add macros or VBA (Visual Basic for Applications) into the mix and WOAH! When I started using Excel VBA with regularity, it seemed like the right VBA code would allow me to see into the future. I’ve used VBA for...
by Oz du Soleil | Apr 14, 2012 | Data Integrity, Data Management, Excel Geekdom, Spreadsheet Development, Tips
Do you work with password protection in Excel spreadsheets? If so, I have good news and bad news. BAD NEWS: the passwords are easy to break GOOD NEWS: the passwords are easy to break If you’re sanitizing data, repairing and modifying spreadsheets, it means...