On average, how many hours per day do you spend working with Excel formulas and/or VBA code?
Right now I pay the bills building Excel/Access systems for various clients. That’s four to eight hours. There are the people I help at sites like Experts-Exchange – another hour or so a day (my wife and the other “experts” on Experts-Exchange will disagree but that’s my answer). And there is the personal time building cool stuff for my own use like adding to my code libraries or trying to find ways to do something new or difficult – another couple of hours. • Which do you find most rewarding to work with: Formulas or VBA in Excel? Please tell us why? The answer depends on the context. I always get a thrill out of using formulas to do what others (and I used to) think can’t be done without VBA. But Excel formulas are very limited in comparison and, within the context in which we can use them, more than just a little arcane. Look at all the hoopla around SUMPRODUCT. On the one hand we espouse its amazing powers and use it to do some amazing things. But on the other hand one has to wonde
Related Questions
- How does it work to use VBA outside of AutoCAD, such as for a user having code in Excel? Does VBA for AutoCAD needed to be installed?
- During an average work week, how many hours do you spend working on the BikerGurlz project?
- How many hours a day or hours a week do you spend working on Go Green Foundation projects?
