Hello everyone! I am quite new at VBA and my boss assigned me a project that requires me to calculate the average, Ann ROR, and standard deviation of various funds using a For Next loop. The spreadsheet given to me has 331 rows and 180 columns. My boss wants me to use Finalrow and FinalColumn in my code. The biggest problem that I have executing a loop is that every column has a different range, meaning that there are blank in-between cells. How would I go about calculating the average using R1C1 type code with loops for starters?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
