Tushar has a great tutorial on his website. It tells you a lot about regression, trendline and using them in VBA. Check it out! Trendline coefficients: “Trendline Coefficients and Regression Analysis”
Continue readingThis is what I had to do lots of times. Send the file path of an Excel workbook to my supervisor. So I created this macro to send the activeworkbook full file path to the specified user. This can actually be well modified to create an AddIn, but for now, this is what is going […]
Continue readingSuppose if you want to increment a cell by 1 to see how your formulae handle that change, may be a simulation. That means that cell would be incremented by 1 everytime you hit F9 (keyboard short cut to make Excel recalculate). To achieve this do the following: 1. On the Tools menu, click Options, […]
Continue readingCheck this article @ MS’s website to know where to get help for VBA programming. List of resources that are available to help you learn Visual Basic for Applications programming
Continue readingAlthough Excel’s Data Analysis Toolpak can generate good random numbers, I had to create these various functions to meet my specific needs. First: Generating Unique Random Numbers This function was modified from ozgrid’s RandLotto function, which returns a string of numbers without duplicates. This function will return an array of unique random integers that are […]
Continue reading