subtotal for many columns

Hi everyone,

I have a table with 3400 columns, and i need to subtotal my database. If I use the subtotal function, I would have to select all the 3400 columns manually. However, also the VBA code that I found should contains the numbers from 2 until 3400 under the TotalList...

Please Login or Register  to view this content.

Somebody has any idea? The number of rows in the subtotal are not the same for each subtotal

Many thanks!

This

Please Login or Register  to view this content.

is not for rows. It is for columns!.

Somehow I do not believe you plan to do separate subtotal for change in each column between B (column2) and column DZT (column3400)

Rows are included in the part:

Please Login or Register  to view this content.

PS. Please edit the post and use code tags, as required by: http://www.excelforum.com/forum-rule...rum-rules.html (also described there how-to)

Wow, that is something.
Almost for sure standard approach will not be appropriate. Can you attach sample file with subset of desensitized data?

OK, reference for Range.Subtotal https://msdn.microsoft.com/en-us/library/bb238221.aspx defines

TotalList Required Variant An array of 1-based field offsets, indicating the fields to which the subtotals are added.

so let's create it:

Please Login or Register  to view this content.