VBA Code to add Excel worksheet in Excel 2007 This code adds a new worksheet. If you leave it as is it will just add the next sheet in the count… if you run in and you have three sheets, … Continued
Formula Auditing in Excel We can spend a lot of time looking for information surrounding formula. Formula Auditing tools help us streamline this process. See topic: HP10066253 Trace Precedents Shows what cells are supplying data to the cell selected. … Continued
Grow Cells when typing in Microsoft Excel I have been looking for the “can grow” option in Excel forever…and I searched for it that way because that is what they call it in Microsoft Access…I have always come up … Continued
Macros: How to Hide them In Excel While They Run I often record short snippets of macros for ease of use and then record myself running all of them. What you can’t record is the screen flickering. We often … 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