| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show/hide cells code
Hi there,
I've got an ammortization table in a spreadsheet. In the last column F, is the ending balance. Once column F reaches 0 (or in most case just goes from + to -), I would like to hide everything underneath it. Any ideas? Thanks, Scot -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show/hide cells code
Hi
you may apply a custom format like 0;;0 -- Regards Frank Kabel Frankfurt, Germany Hi there, I've got an ammortization table in a spreadsheet. In the last column, F, is the ending balance. Once column F reaches 0 (or in most cases just goes from + to -), I would like to hide everything underneath it. Any ideas? Thanks, Scott --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show/hide cells code
Thanks Frank,
I never knew of that function. There is a problem though. Column contains dates, B contains positive #'s. I need everything to disappea underneath the last row when Column F turns negative. Thank -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to hide and show a grouped column via VBA code? | Excel Discussion (Misc queries) | |||
| How to show columns/cells in sheet but hide them in print? | Excel Discussion (Misc queries) | |||
| Hide n' show cells in protected sheet | Excel Worksheet Functions | |||
| macro to hide then show cells | Excel Discussion (Misc queries) | |||
| Want to show/hide cells depending on other cells results | Excel Discussion (Misc queries) | |||
![Scottmk[_16_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
