hidding a column based on an outcome to an if statement

[dusty]

I need to know how to compare a collumn with a cell and hide the collum the cell is in if any of the cells from the collumn do not match the cell

for example IF collumn A( from A3 till end) does not = B2 hide collumn B

also can this be continuosly running so that if the collum changed hidden collums could be unhiden and new ones hidden?

Cheers Dusty

 

[HaHoBe]

Hi, Dusty,

I do have some problems understanding what you are after. Maybe the VBA Code

Range("B2").EntireColumn.Hidden = (WorksheetFunction.CountIf(Range("A3:A" & Rows.Count), Range("B2")) > 0)

may give you a hint where to go (if a column is hidden you can´t use the column itself for any start of a procedure or an event, so I think the Worksheet_Change event won´t be of much use here).

Ciao,
Holger

 

[dusty]

thanks for the reply