(Msg. 1) Posted: Fri Jan 15, 2010 5:08 pm
Post subject: formula to hide a row in excel 2007 Archived from groups: microsoft>public>excel>misc (more info?)

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

(Msg. 2) Posted: Fri Jan 15, 2010 5:30 pm
Post subject: RE: formula to hide a row in excel 2007 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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?

(Msg. 3) Posted: Fri Jan 15, 2010 5:56 pm
Post subject: RE: formula to hide a row in excel 2007 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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?

(Msg. 4) Posted: Fri Jan 15, 2010 6:01 pm
Post subject: RE: formula to hide a row in excel 2007 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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?

(Msg. 5) Posted: Fri Jan 15, 2010 6:09 pm
Post subject: RE: formula to hide a row in excel 2007 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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?

(Msg. 6) Posted: Fri Jan 15, 2010 7:18 pm
Post subject: Re: formula to hide a row in excel 2007 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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?

(Msg. 7) Posted: Fri Jan 15, 2010 7:18 pm
Post subject: Re: formula to hide a row in excel 2007 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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?
>
> .
>

(Msg. 8) Posted: Fri Jan 15, 2010 10:16 pm
Post subject: Re: formula to hide a row in excel 2007 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)

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?

You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum