Thread: Hidden Column in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
norika norika is offline
external usenet poster
  
Posts: 1
Default 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 QuoteReply With Quote