I use an early version of Netscape Messenger for my newsreader. For me it was
just a timing issue.

Dean wrote:

Possibly your problem is like mine: I have noticed that, when using Outlook
Express, only recently, if the title of my post is the same as any other one
that has ever been posted to this newsgroup(!), it gets included underneath
the old original post by someone else, which makes it difficult to find,
even when OE is set to just show replies to my messages. I guess I need to
start using very unique titles. I don't recall that this was the case ever
before (perhaps I somehow changed an OE setting).

Thanks!
Dean

"Dave Peterson" wrote in message
...
When I retrieved the headers in this newsgroup, Tom's response wasn't
there yet.



Dean wrote:

Wow, what a response!

Dave, I'm not sure what your point was, seemingly praising Tom's approach
but still offering a slightly different macro. How is yours different
from
Tom's? Are you just pointing out that it is case sensitive, so the lcase
(I
assume that's lower case) is safer?

In any event, I thank everyone, as it looks like any of these will do the
trick.

Dean

"Dave Peterson" wrote in message
...
Sometimes using the "select case" syntax makes things easier to see.

Option Explicit
Sub testme()
With ActiveSheet
Select Case LCase(.Name)
Case Is = "sheet1", "sheet2", "sheet3"
.Rows(16).Hidden = True
Case Is = "sheet4"
.Rows(4).Hidden = True
Case Else
'do nothing
End Select
End With
End Sub

ps. this is a text only newsgroup--please post in plain text (not HTML
and no
attachments).

Dean wrote:

Can someone give me the exact code for the following general
situation:

If the active worksheet when a macro is called is sheet 1 or sheet2 or
sheet3,
then hide row 16. Or, if sheet 4, hide row 18. If any other sheet,
don't
hide anything - that I suppose requires no text!

Thanks!
Dean

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson