Hello!
I have a report that is generated by a macro. The macro copies another worksheet into a new worksheet, hides rows and columns to show a condensed version of the original worksheet.
Now, I need to sum some of the columns (3 columns). I found a code in MS forum to sum one column, and every other example I find elsewhere only shows 1 column. I need 3 columns summed.
Also, the new report is filtered, so I cannot sum the entire column, just the visible rows.
So, to sum column U, I have:
It works great. Now, I need to sum columns Y and Z also.Please Login or Register to view this content.
I have tried to dup this step with the additional ranges, but I get a duplicate Range error. I have also tried incorporating Y3:Y and Z3:Z into the Active.Sheet.Range, but I get an error with the range doing that.
So, I am wondering how to add the totals for the additional 2 columns.
Any help would be greatly appreciated! Thank you!
Bookmarks