Quote:
Originally Posted by sungar78
This makes a lot of sense. Thank you for the explanation and for runningu it!
If you don't mind me asking a follow up question, what is VBA?
It stands for Visual Basic Applications. It is a programming tool to solve problems using the Excel spreadsheet and functions. For example, if you have a column of data in cells A5, A6, …, A10, you can get the sum of squares with the following code:
SumSq =0
For I = 5 to 10: SumSq = SumSq + Range(“A” & I)^2: Next
Range(“A” & 12)= SumSq