Dear Excel Helpers,
I need your help in doing Subtotals on a file using VBA codes. The datafile I receive every month has unknown number of rows and columns, i.e., each file has rows and columns that are not fixed. I want to do three levels of subtotals on this file based on columns 2, 3, and 4 in that order. The subtotaling columns will start from column 8 to that last column with data in that file. What I cannot figure out is what to specify within the array in the subtotal function through vba codes when the number of columns are not known.
Thank you for all help