what is the formula to unhide row 27 if the value of cell C6 is greater than 0?

Formulas ONLY return values. You need a worksheet_change macro

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"adamcr64" wrote in message
...
what is the formula to unhide row 27 if the value of cell C6 is greater
than 0?

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)


"adamcr64" wrote:

what is the formula to unhide row 27 if the value of cell C6 is greater than 0?

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

"Mike H" wrote:

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)


"adamcr64" wrote:

what is the formula to unhide row 27 if the value of cell C6 is greater than 0?

is this something i can do for this worksheet?
"Don Guillett" wrote:

Formulas ONLY return values. You need a worksheet_change macro

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"adamcr64" wrote in message
...
what is the formula to unhide row 27 if the value of cell C6 is greater
than 0?

.

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)


"adamcr64" wrote:

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

"Mike H" wrote:

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)


"adamcr64" wrote:

what is the formula to unhide row 27 if the value of cell C6 is greater than 0?

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
"Mike H" wrote:

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)


"adamcr64" wrote:

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

"Mike H" wrote:

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)


"adamcr64" wrote:

what is the formula to unhide row 27 if the value of cell C6 is greater than 0?

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.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"adamcr64" wrote in message
...

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
"Mike H" wrote:

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)


"adamcr64" wrote:

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

"Mike H" wrote:

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)


"adamcr64" wrote:

what is the formula to unhide row 27 if the value of cell C6 is
greater than 0?