Prev: eliminating unwanted data
Next: how do I display last two digits of a SSN in a separate column
From: jm913 on 31 Jan 2010 22:50
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!
From: Per Jessen on 1 Feb 2010 02:53
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" <jm913(a)discussions.microsoft.com> skrev i meddelelsen
news:D7A64EE8-A171-41BB-9926-40AB70309426(a)microsoft.com...
>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!

 | 
Pages: 1
Prev: eliminating unwanted data
Next: how do I display last two digits of a SSN in a separate column