VB Code to hide and unhide rows

[ateebali]

Dear Sir
Using following code;

Sub Macro1()
'
' Macro1 Macro
'


'
Range("A7:A8").Select
Selection.EntireRow.Hidden = False


End Sub

It is linked with button, when I click it, its Unhide the rows A7:A8
I need to write the code then when we click again, it should hide A10:A11
then when click again it should hide A13:A14

 

[Rick Rothstein]

Give this code a try...

Sub Macro2()
  Rows("7:8").Hidden = Not Rows("7:8").Hidden
End Sub

 

[mole999]

could something be hidden on sheet, so when the user clicks the button to swap, the number is updated for the next triple ?

 

[ateebali]

Yes wanted to do it for next triple
When click once, row A7:A8 unhidden
then again click same button, so it will unhide row A9:A10
again A12:A13, it will go like wise to bottom till A250, it will be ending

 

[Fluff]

Your requirements are changing, in post#1 you said
A7:A8
A10:A11
A13:A14
in post#4 you said
A7:A8
A9:A10
A12:A13

Which is correct?
Also are all rows 7:250 hidden to begin with?

 

[ateebali]

Dear Sir,
I want to understand vb code with formula, as requirement can be changed if I add more rows, still I am finalizing the format sheet, currently requirement is as;
All rows are hidden except A1:A6 (complete row)
I have made a button (Form Control) need to link it with vb code, when I click it first time, it will show row# A9:A10 and keep hidden Row A7:A8
When Click sever time, it will unhide next rows for example, A13:A14 (A11:A12 will keep hidden)
Next press will unhide A17:A18 (A15:A16 will keep hidden)
Similarly It goes till A250 this is where I want to end my data at max.
Formula will remain same like 02 rows jump or 03 rows jump or 01 row jump over to the last

 

[Fluff]

How about

Sub ateebali()
   Dim Ar As Areas
   Set Ar = Range("A5:A250").SpecialCells(xlVisible).Areas
   Ar(Ar.Count).Offset(4).Resize(2).EntireRow.Hidden = False
End Sub

 

[Rick Rothstein]

Alright, I am confused. When you first start, is range 7:250 hidden? If yes, then the first time you run the macro, you want rows 7:8 visible, correct? What happens next is where I'm confused. The next time you run the macro, you want rows 10:11 made visible, but what about rows 7:8... do they stay visible also or are they to become hidden?

 

[ateebali]

Sir yes 7:8 keep visible

 

[ateebali]

This is perfect code, thanks a lot
Please also advice code for reverse, this time it will hide the rows from bottom first.
For example if ROW 21:22 is visible, it will hide 21:22 fir first click, next click, it will hide 17:18, next it will hide 13:14
It will also through row 250