A
adamcr64
what is the formula to unhide row 27 if the value of cell C6 is greater than 0?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
Formulas ONLY return values. You need a worksheet_change macro
M
Mike H
Hi,
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)
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)
A
adamcr64
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
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
A
adamcr64
is this something i can do for this worksheet?
Don Guillett said:Formulas ONLY return values. You need a worksheet_change macro
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
.
M
Mike H
Hi,
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)
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)
A
adamcr64
Hi It is a input value. I have several hundred of these to write on a
single worksheet. Can that be done using these macros?
Adam
single worksheet. Can that be done using these macros?
Adam
D
Don Guillett
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.
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.