Show/hide cells code

  • Thread starter Thread starter Scottmk
  • Start date Start date
S

Scottmk

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide/Show rows based on Conditions 3
Hide rows issue 3
Excel VBA 1
Refer a column in the 'sumif' function 2
Display rows if conditions met 2
Modify working code to expand the output. 5
Problem sorting a range of columns using VBA 1
Code won't fill to last row in table 4

Back
Top