Hide columns with macros

I love this place. The more questions I have answers, the more dependent I become because the more I realize is possible, that I can't do.

This time, I'm trying to hide columns based on values on certain cell values.

Here's the macro I'm using...

Please Login or Register  to view this content.

I WANT the macro to look at cells and if the cell is empty hide the column...
If AL155 is empty, hide Column AL
...
If EZ155 is empty, hide Column EZ

When I run this macro though, it just hides all columns from AL to EZ.

Do I have to create new macros for each column? or is it possible with a single macro?

Thanks again guys!

shg, I tried the code you suggested, but that didn't appear to do make anything disappear.

I should mention that the AL155:EZ155 are not simple strings or numbers...
here's what I have in the cells...

Please Login or Register  to view this content.

Some of the cells are "empty" as in they don't display anything because the linked cell is empty.

Originally Posted by shg

Please Login or Register  to view this content.

Thanks, sorry for the confusion earlier. Worked like a charm!

Hey, one more question...

Excel is limited 256 columns and I have a few hundred rows, so I can't transpose my data.
This will require me to move the columns I would have liked to have to the right of the ones I have on the next row...
Is there a way to hide columns if two cells don't display characters?

Here's what I have been using...

Please Login or Register  to view this content.

So I would like to check BB26:IA26 and BB52:IA52 and if they BOTH yield "", then hide the column.

My instinct say it's not possible...hopefully it is though!

Thanks again guys!

See if this works for you.

Please Login or Register  to view this content.

HTH

Jason

Originally Posted by jasoncw

See if this works for you.

Please Login or Register  to view this content.

HTH

Jason

Worked like a charm...
Thanks, Jason!