Posted to microsoft.public.excel.programming

norika

external usenet poster

Posts: 1

Hidden Column in VBA

Selecting 'Group Sheet' and hide column using VBA.

Sheets(Array("sheet1", "sheet2", "sheet3")).Select
Sheets("sheet1").Activate
Range("A:A,D:F,J:J,N:O").Select
Selection.EntireColumn.Hidden = True

The result was only "Sheet1" can hide the column, the other cannot.

Any ideas?

Norika

---
Message posted from http://www.ExcelForum.com/

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
getting rid of a hidden column behind the front column	mamie1159	Excel Discussion (Misc queries)	1	February 3rd 10 03:10 AM
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da	Tammy	Excel Discussion (Misc queries)	3	April 2nd 09 11:40 PM
Hidden Column A	ebf kentucky	Excel Discussion (Misc queries)	3	June 12th 08 06:34 PM
hidden column	oldLearner57	Excel Discussion (Misc queries)	1	March 27th 08 01:40 PM
Hidden column	Joe	Excel Discussion (Misc queries)	7	August 11th 07 08:33 PM

All times are GMT +1. The time now is 06:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us