So basically I haeve a worksheet set up, with 11 columns, and 80 rows.
The 11th column is a 'Total' column. At the moment it either sums or averages the values in the preceding column (dependent upon which row).
However there are currently 4 hidden columns between the 10th and the totals column. There is also a little 'Add' button which unhides the first hidden column.
However when unhidden I want this column to be included in the sum range. However I don't know how to do this, without manually changing it.
For instance
columns A-J are unhidden. K,L,M & N are hidden and O is the 'Totals' column. The formula in O1 = sum(A1:J1). The user clicks 'Add' and column K is unhidden, the sum in O1 should now = sum(A1:K1)
The 11th column is a 'Total' column. At the moment it either sums or averages the values in the preceding column (dependent upon which row).
However there are currently 4 hidden columns between the 10th and the totals column. There is also a little 'Add' button which unhides the first hidden column.
However when unhidden I want this column to be included in the sum range. However I don't know how to do this, without manually changing it.
For instance
columns A-J are unhidden. K,L,M & N are hidden and O is the 'Totals' column. The formula in O1 = sum(A1:J1). The user clicks 'Add' and column K is unhidden, the sum in O1 should now = sum(A1:K1)
