Andy

Posts: n/a

Macro for Show/Hide Column

worked well. chose this one.

"tjtjjtjt" wrote:

Here's a basic macro that will do it:

Sub HideColD()
Columns("D:D").Select
If Selection.EntireColumn.Hidden = False Then
Selection.EntireColumn.Hidden = True
Else
Selection.EntireColumn.Hidden = False
End If
Range("D1").Select
End Sub

tj

"Andy" wrote:

Hi

I am trying to write a Macro to Toggle Show/Hide column D

Anybody able to help?

with thanks...Andy

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
Combine candle and line in a single chart	Bert	Charts and Charting in Excel	4	January 19th 05 07:23 AM
hide column but show chart	Svetlana	Charts and Charting in Excel	1	January 14th 05 09:49 AM
Column A is Town, Column B is names. How can Excel add & tell how.	Cindy	Charts and Charting in Excel	3	January 13th 05 07:27 PM
On a combination chart how do i get 2 lines and 1 column?	Richie	Charts and Charting in Excel	1	December 22nd 04 12:27 PM
Change the width of a single column in a column chart	Dave	Charts and Charting in Excel	2	December 13th 04 07:25 PM

All times are GMT +1. The time now is 12:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us