Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically hide unused columns
I have a 10 year schedule which returns values to a defined point. Is there
a way to hide the unused columns with the numerical value i am entering. As an example If i want to show 60 months of cash flow can i hide the other 60 when i enter this value. -- Thanks for your help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically hide unused columns
Hi
You do not say where you want to enter # of month to show, so I used an inputbox. Sub HideUnusedCols() Dim showCF As Long Dim FirstDataColCell As Range Dim FirstDataCol As Long Dim LastDataCol As Long showCF = InputBox _ ("How many month of cash flow do you want to show ?", "Regards, Per") FirstDataCol = 2 'Titles in column 1 LastDataCol = 121 Set FirstDataColCell = Cells(1, FirstDataCol) FirstDataColCell.Resize(1, LastDataCol - FirstDataCol + 1) _ .EntireColumn.Hidden = False If showCF < 120 Then FirstDataColCell.Resize(1, LastDataCol - showCF - FirstDataCol + 1) _ .EntireColumn.Hidden = True End If End Sub Regards, Per "jm913" skrev i meddelelsen ... I have a 10 year schedule which returns values to a defined point. Is there a way to hide the unused columns with the numerical value i am entering. As an example If i want to show 60 months of cash flow can i hide the other 60 when i enter this value. -- Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically hide empty columns in Excel? | Excel Discussion (Misc queries) | |||
Hide unused rows and columns | Excel Discussion (Misc queries) | |||
How do I automatically hide columns? | Excel Discussion (Misc queries) | |||
hide columns automatically | Excel Programming | |||
Automatically hide/unhide columns | Excel Discussion (Misc queries) |