I have an Excel macro that does an Auto-Sum of data in columns, O, P, and Q of my spreadsheet.
That's great. But, at this point, my spreadsheet has 459 rows of data. Next month, it may have 500 rows of data. The following, it may have 420, etc.
My macro is placing the Auto-Sum in row 460. But, I want it to be versatile and sum the values in these three columns--no matter what the number of rows is.
So, I need one of two things. I need for someone to tell me either (a) what keystrokes I can use to accomplish this so that I can re-record my macro or (b) help me modify my macro's code below to accomplish this.
Selection.FormulaR1C1 = "=SUM(R[-458]C:R[-1]C)"