I need to hide and unhide columns in a spreadsheet. My problem is that
different sets of columns are being hidden depending on the data I need. I
can create a basic macro, but can't seem to get it to work when I select more
than one column (either a range or non consecutive sets [i.e. columns C and E
or C,D, and F, etc]).

Any suggestions?

I have an addin that does this. Would you like me to email it to you?

Charles Chickering
xl Geek

Monique wrote:
I need to hide and unhide columns in a spreadsheet. My problem is that
different sets of columns are being hidden depending on the data I need. I
can create a basic macro, but can't seem to get it to work when I select more
than one column (either a range or non consecutive sets [i.e. columns C and E
or C,D, and F, etc]).

Any suggestions?

For Each col In Selection.Columns
col.Hidden = True
Next col

will hide them, but how will you select hidden columns?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Monique" wrote in message
...
I need to hide and unhide columns in a spreadsheet. My problem is that
different sets of columns are being hidden depending on the data I need.
I
can create a basic macro, but can't seem to get it to work when I select
more
than one column (either a range or non consecutive sets [i.e. columns C
and E
or C,D, and F, etc]).

Any suggestions?

My thought was that I could select all the columns in my spreadsheet and run
the macro to unhide columns. This should unhide all columns. This is what I
need anyway, because I would need to select a new set of columns to hide for
the next step in my process.

Can or should I turn your macro statement into an if/then statement?

"Bob Phillips" wrote:

For Each col In Selection.Columns
col.Hidden = True
Next col

will hide them, but how will you select hidden columns?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Monique" wrote in message
...
I need to hide and unhide columns in a spreadsheet. My problem is that
different sets of columns are being hidden depending on the data I need.
I
can create a basic macro, but can't seem to get it to work when I select
more
than one column (either a range or non consecutive sets [i.e. columns C
and E
or C,D, and F, etc]).

Any suggestions?

Once all columns are selected press Ctrl+Shift+) to unhide all columns.

Charles Chickering
xl Geek

Monique wrote:
My thought was that I could select all the columns in my spreadsheet and run
the macro to unhide columns. This should unhide all columns. This is what I
need anyway, because I would need to select a new set of columns to hide for
the next step in my process.

Can or should I turn your macro statement into an if/then statement?

"Bob Phillips" wrote:

For Each col In Selection.Columns
col.Hidden = True
Next col

will hide them, but how will you select hidden columns?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Monique" wrote in message
...
I need to hide and unhide columns in a spreadsheet. My problem is that
different sets of columns are being hidden depending on the data I need.
I
can create a basic macro, but can't seem to get it to work when I select
more
than one column (either a range or non consecutive sets [i.e. columns C
and E
or C,D, and F, etc]).

Any suggestions?

PERFECT!!!!!
Thanks to both of you for the help.

"Die_Another_Day" wrote:

Once all columns are selected press Ctrl+Shift+) to unhide all columns.

Charles Chickering
xl Geek

Monique wrote:
My thought was that I could select all the columns in my spreadsheet and run
the macro to unhide columns. This should unhide all columns. This is what I
need anyway, because I would need to select a new set of columns to hide for
the next step in my process.

Can or should I turn your macro statement into an if/then statement?

"Bob Phillips" wrote:

For Each col In Selection.Columns
col.Hidden = True
Next col

will hide them, but how will you select hidden columns?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Monique" wrote in message
...
I need to hide and unhide columns in a spreadsheet. My problem is that
different sets of columns are being hidden depending on the data I need.
I
can create a basic macro, but can't seem to get it to work when I select
more
than one column (either a range or non consecutive sets [i.e. columns C
and E
or C,D, and F, etc]).

Any suggestions?