Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Hiding one column at a time in a range
I am looking for a macro code that I could attach to command buttons on a
worksheet. I have a table beginning on Column L and goes out to Column BJ which consists of data for Work Week End Dates (1/9 to 12/25). I would like to have one button hide the first column in the data table (Column L). When clicked again, it would hide Column M, clicked again it would hide Column N, etc. The second button when clicked I would like to unhide all of the columns in the range (Columns L to BJ). I am still a novice at macros and VB so any help would be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Hiding one column at a time in a range
GoBucks,
I have assumed that you did not want to unhide L when you hide M.... Sub HideColumns() Range("L:BJ").SpecialCells(xlCellTypeVisible).Cell s(1).EntireColumn.Hidden = True End Sub Sub UnhideAllColumns() Range("L:BJ").EntireColumn.Hidden = False End Sub HTH, Bernie MS Excel MVP "GoBucks" wrote in message ... I am looking for a macro code that I could attach to command buttons on a worksheet. I have a table beginning on Column L and goes out to Column BJ which consists of data for Work Week End Dates (1/9 to 12/25). I would like to have one button hide the first column in the data table (Column L). When clicked again, it would hide Column M, clicked again it would hide Column N, etc. The second button when clicked I would like to unhide all of the columns in the range (Columns L to BJ). I am still a novice at macros and VB so any help would be appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Hiding one column at a time in a range
Bernie, Thank You!!! Worked Great!
"Bernie Deitrick" wrote: GoBucks, I have assumed that you did not want to unhide L when you hide M.... Sub HideColumns() Range("L:BJ").SpecialCells(xlCellTypeVisible).Cell s(1).EntireColumn.Hidden = True End Sub Sub UnhideAllColumns() Range("L:BJ").EntireColumn.Hidden = False End Sub HTH, Bernie MS Excel MVP "GoBucks" wrote in message ... I am looking for a macro code that I could attach to command buttons on a worksheet. I have a table beginning on Column L and goes out to Column BJ which consists of data for Work Week End Dates (1/9 to 12/25). I would like to have one button hide the first column in the data table (Column L). When clicked again, it would hide Column M, clicked again it would hide Column N, etc. The second button when clicked I would like to unhide all of the columns in the range (Columns L to BJ). I am still a novice at macros and VB so any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A formula or macro that will place the date in an adjacent column Bany time something is typed in column A | Excel Programming | |||
Unhide 1 column at a time from named range | Excel Programming | |||
Hiding Column Also hiding text | Excel Programming | |||
Hiding Rows in a Range based on column A value | Excel Programming | |||
EXCEL Sum column based on time range in different column? | Excel Worksheet Functions |