You can't do that with a formula, it would have to be a macro. Tell us about
C6, is it a value that you enter or a formula?
--
Mike
When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''s razor (Abbrev)
This is for a customer incoming order. there are several hundred items and as
a value is added to a item it causes to item information line to unhide. C6
is one of the hundreds that need to be done
Well you didn't answer the question as the whether C^ was an input value or
a formula but we'll go with this for now. Right click your sheet tab, view
code and paste the code in and then close VB editor. Now every time the
worksheet calculates the code will check C6 and hide/undide row 27 as
appropriate.
Private Sub Worksheet_Calculate()
If Range("C6").Value > 0 Then
Rows(27).Hidden = True
Else
Rows(27).Hidden = False
End If
End Sub
--
Mike
When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''''s razor (Abbrev)
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
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.
