Microsoft Excel Should Be Easy to Use Based on my 37 years of programming in Microsoft Excel, I can personally tell you that there is absolutely no reason for Excel to frustrate you, or for Excel to be difficult to use. Simply put, Microsoft Excel should be easy to use. If Excel is not [...]
If you've used tables before you have seen your formulas automatically expand and contract with your data. This is a pretty handy feature of the tables. Some might say they just copy and paste the formulas, but this is not true. (See this blog post to see why structured table references should be used, which [...]
This blog post will be based on working with tables via VBA. They present some unique issues, which has to do with how their structured in the object model. Good or bad, it's what we have. These are based on my trial and errors, so hopefully this will help somebody out there. That being [...]
