Hi, I have a spreadsheet, which uses the colour of the first cell in a
column, to indicate the team that the column belongs to.

I would like to be able to select multiple columns (between B and AB)
based on the colorindex of this first cell.

For example, if the colorindex of Columns B, D, J and Z is 10, I would
like to hide all columns in the range ("B:AB") and then unhide columns
B, D, J and Z.

Example 2, if the team member in column B swaps places with the member
in Column P, then if the colorindex of Columns D, J, P and Z is 10, I
would like to hide all columns in the range ("B:AB") and then unhide
columns D, J, P and Z.

Example 3, if the colorindex of Columns F, K, L and Q is 15, I would
like to hide all columns in the range ("B:AB") and then unhide columns
F, K, L and Q.

Is there an easy way to achieve this.

Problem Resolved.

I selected all the columns in the range I am working with and Hid them
I then looped through all the columns and if the colorindex matched,
selected that column and made it visible, then continued through the
loop selecting each single column and unhiding where applicable.


rcg wrote:
Hi, I have a spreadsheet, which uses the colour of the first cell in a
column, to indicate the team that the column belongs to.

I would like to be able to select multiple columns (between B and AB)
based on the colorindex of this first cell.

For example, if the colorindex of Columns B, D, J and Z is 10, I would
like to hide all columns in the range ("B:AB") and then unhide columns
B, D, J and Z.

Example 2, if the team member in column B swaps places with the member
in Column P, then if the colorindex of Columns D, J, P and Z is 10, I
would like to hide all columns in the range ("B:AB") and then unhide
columns D, J, P and Z.

Example 3, if the colorindex of Columns F, K, L and Q is 15, I would
like to hide all columns in the range ("B:AB") and then unhide columns
F, K, L and Q.

Is there an easy way to achieve this.