I thought it would be fun to show you how to not display ugly valid errors, like DIV/0, when it’s there because there is a 0, but doesn’t need to show, because everyone knows that it’s zero. Also love to get … Continued
We are working on our newest guides. We thought it might be fun to share with you one of our current mockups. If you learn something from it – please like and it and share it!
Our latest project? Building data warehouses or marts. How we do this is by training the end users how to use the tools that IT has diligently put in place. We meet great end users all the time. They aren’t … Continued
Excel VBA Loops Here are some great places for code on loops in Excel, no two scenarios are exactly the same…but you can use this to get started… http://support.microsoft.com/kb/299036 http://stackoverflow.com/questions/1128841/how-to-loop-through-rows-columns-in-excel-vba-macro http://stackoverflow.com/questions/17001631/excel-vba-looping-through-rows-and-copy-cell-values-to-another-worksheet http://www.ozgrid.com/forum/showthread.php?t=64445 Remember, if you’re not frustrated – then you’re … Continued