macro to hide/unhide columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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 said:
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 said:
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?
Click to expand...
Click to expand...
 
Once all columns are selected press Ctrl+Shift+) to unhide all columns.

Charles Chickering
xl Geek
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 said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
PERFECT!!!!!
Thanks to both of you for the help.

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

Charles Chickering
xl Geek
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 said:
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)

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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top