View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Robert is offline
external usenet poster
 
Posts: 113
Default Hide/Unhide 10 consecutive rows down

I have gone through previous posts but could not get the correct/similar code
for:-
1.when command button(1) is clicked, 10 rows down (if hidden) from an
active cell should be unhidden i.e. if B4 is active cell, rows 5 to 14
should be unhidden
2.when command button(2) is clicked, 10 rows down (if not hidden) from a
active cell should be hidden i.e. if B40 is the active cell, rows 41 to 50
should be hidden.
Would appreciate assistance
--
Robert