VBA exclude column within range

[syedmehdi]

Hi all,

I have a piece of VBA code which hides and shows specific columns within a range based on the value of a particular cell.
I have attached an example spreadsheet to demonstrate this, i.e. the variable cell being B2. If you type "A" into this cell, columns that have "A" in row 2 will only show. The same is true if you type "B".

My range is currently looking at D2:H2 however I wish to omit column F from the range. I'm new to VBA hence not sure what the correct syntax is for omitting columns.

The code i have used for Sheet 1 is as follows:

Please Login or Register  to view this content.

Thank you in advance, any feedback much appreciated.

[Norie]

Try this.

Please Login or Register  to view this content.

The highlighted part checks the column isn't column 6 (F).

[syedmehdi]

That has worked perfectly. I was playing around with And but couldn't wok out where to put it (was trying to incorporate it into the Set headers line).

Thanks for the solution and speedy response