Under Data tab, we have Group option is der na...to group rows....
In an excel sheet i have 700 rows, in which after say some 'n' rows an empty line is der which divides the above and below rows....(This 'n' is avariable)
I want to group the rows till the empty line.....Grouping the rows manually is a little bit tedious...so i thought of using macro to do this...
I recorded macro for this....In that it came like....

Rows("14:31").Select
Selection.Rows.group

I want to parameterize this in such a way that it will group the rows till an empty line comes and this repeats till the end of the sheet