A Quick VBA to hide all Columns with "i" in row 1?

[tonywatsonhelp]

Hi Everyone,

I need a fast VBA to hide all Columns Between B and AAZ that have "i" in row 1?

What im trying to do is have a macro that hides certain parts of my document when its not nesseccacary to see them, however the requirements are changing a lot so just listing the columns i want to hide means i have to keep editing the macro,

If i could have a macro that just hides them if they say "i" this would be great but if we try it with a loop it seams to take a long time as it hides each column one at a time, I'm happy to have extra things like a formula or whatever the best idea is i just want to be able to add or remove "I" from row 1 and that column be included in the hide.

any ideas would be welcomed

Thanks

Tony

 

[Fluff]

What is in row 1 for the columns you want visible?

 

[tonywatsonhelp]

"i"

 

[MARK858]

to hide all Columns Between B and AAZ that have "i" in row 1?

What is in row 1 for the columns you want visible?

"i"

Hi @tonywatsonhelp, I am afraid your statements above don't tally.

 

[tonywatsonhelp]

Hi sorry its late here and i've lost the ability to read lol,
i'm setting this up to do whatever it needs to at the moment i have row 1 blank except for the cells with "i" in them, but i can add something if need be?
Thanks
Tony

 

[MARK858]

If your cells are truly blank and your i is a constant then you could just use

Rows("1:1").SpecialCells(xlCellTypeConstants, 23).EntireColumn.Hidden = True

 

[tonywatsonhelp]

Thank you Mark,
This is great
Tony

 

[MARK858]

You're welcome...
P.S. Tony it didn't make a difference here but can you at some stage update your profile please so that it shows your Excel/OS version, as it does help us when answering questions.