Hiding 1 Row also hides a different row

[Nate5452]

Is there any Function out there that will allow me to automatically hide an addition row if I were to hide a row on the same sheet.


For Example:

I right click on Row 5; then click hide. I would like to automatically hide Row 10 at the same time.


Thanks
Nathan

[mikerickson]

Is this just 5 and 10 or are there other rows you want paired?

[Nate5452]

thats just one example, but it will be no more than two lines paired together. And it will be the same lines each time and no more than about 12 lines total will be paired.


For example:
Hiding line 15 automaticall hides line 84
Hiding line 25 automatically hides line 88
and so on.


thank you
Nate

[RingorSkyrus]

I would just use simple if statements.

If Cells(15, 0).EntireRow.Hidden = True Then
Cells(25, 0).EntireRow.Hidden = True
End If

And just write 12 of them for the rows you want to pair.

[mudraker]

RingorSkyrus

Please read forum rules & wrap your VBA code - see links below


If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950

[Nate5452]

Didn't work, Maybe I'm not understanding the Code, Thanks though.


Nate