Posted to microsoft.public.excel.programming

Saintsman

external usenet poster

Posts: 81

Hide unhide non-contiguous columns

I use the following code to hide/unhide a range of cells using a tick box
With Columns("O:W")
.Hidden = Not .Hidden
End With

I want to do exactly the same for columns G,J,P,R ie if they are hidden then
unhide them, if they are not hidden then hide them
Any help appreciated

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hide/Unhide columns using button on top over relevant columns	[email protected]	Excel Discussion (Misc queries)	1	March 7th 07 09:24 PM
I set up a macro to hide/unhide columns. It hides more columns	Lori	Excel Programming	1	September 6th 06 04:08 PM
Hide non-contiguous columns	BEEJAY	Excel Programming	2	May 23rd 06 01:25 PM
Hide and unhide columns	Frederic	Excel Programming	2	September 14th 05 09:53 PM
hide / unhide columns	appeng	Excel Programming	1	March 25th 05 10:16 PM

All times are GMT +1. The time now is 08:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us