Hello,

I'm not sure if this is the correct group or not so pls forgive me if
this question is too 'beginner'.

I'm looking to hide/unhide rows 23 through 29 in a worksheet I have if/
when I dbl click on cell C22. The only example I can find that leads
me in this direction is:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
If Not Application.Intersect(Target, Range("s25")) Is Nothing Then
Columns(35).EntireColumn.Hidden = Not
Columns(35).EntireColumn.Hidden
End If
End Sub

But something was mentioned regarding if 'you want to simply toggle
visibility and not enter into edit mode then you'll have to Cancel =
True'. Well, I want only to toggle visibility and don't care for edit
mode. I can get the example above to work for it's intended
purpose. . . but am failing to modify if for my own purposes.

Can someone tell me how to covert the example to work on a range of
rows, and what Cancel = True means and how to implement it.

Thanks for you patients,
Bones