Hi Guys,

Hopefully this is quite a simple bit of VBA code...

I have a sheet which contains data from column E to column BT.

Row 1 contains the titles - I have conditionally formatted these to use fill color Grey (R-128, G-128, B-128) if they are not required.

I need some VBA that will do the following.

- Look at each cell on row 1 between column E and BT,

- If the cell in row 1 is conditionally formatted with Grey Fill (R-128, G-128, B-128) then hide the column.

That's it, I just can't figure out how to write it!

Many thanks for any help