Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm building a pro-forma financial statement that will evaluate an
investment for a given number of years. I need to be able to put in a number specifying how long I will hold the investment in cell I-6 on a worksheet called "Data Entry", and then add or subtract columns on a worksheet called "operating Statement" based on the number from the data entry worksheet. The maximum holding period is 10 years, so I figure the easiest way to do this is to just build my worksheet to have columns for years 0-10, and then use the macro to hide columns if the holding period is less than 10. Example, if the holding period is 5, I want the macro to hide columns 6-10. How do I do this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hiding rows or columns based on cell contents | Excel Discussion (Misc queries) | |||
Hiding columns based on row 4 criteria | Excel Worksheet Functions | |||
Hiding columns based upon a value (or vice versa) | Excel Programming | |||
Hiding columns based on user/password | Excel Worksheet Functions | |||
Hiding columns in another Worksheet | Excel Programming |