Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Promote / Demote
I will like to hide and exanpand columns in a spread
sheet. I was sucesfully doing this grouping the columns in the Data menu and using the outline function. Does anybody know hat to hide and show the columns fron a VBA code? Thanks, Giuseppe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Promote / Demote
Hi,
To hide the columns A to K : Columns("A:K").Hidden = True to show : Columns("A:K").Hidden = false With a loop you can do the same thing as follows : Dim i as integer i = 1 For i = 1 to 10 Columns(i).Hidden = true Nex -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Promote / Demote
The easiest way is to record a macro while you do it.
Regards BrianB ========================================== "Giuseppe" wrote in message ... I will like to hide and exanpand columns in a spread sheet. I was sucesfully doing this grouping the columns in the Data menu and using the outline function. Does anybody know hat to hide and show the columns fron a VBA code? Thanks, Giuseppe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to promote/demote Excel rows to new outline group level? | Excel Discussion (Misc queries) | |||
Promote Your Website 72865 | Excel Worksheet Functions | |||
Get paid to promote my site | Excel Worksheet Functions | |||
Get paid to promote my site | Setting up and Configuration of Excel | |||
Get paid to promote my site | Links and Linking in Excel |