Need VBA code to count number of rows & split into group of 7 rows in same sheet

Dear All,

i have excel which contain data in several rows , I want Marco to be split the rows in groups , 7 possible rows in each group . in same sheet


Example:-

Data

AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA

Result should be

AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA

AA AA AA AA AA AA AA
AA AA AA AA AA AA AA
AA AA AA AA AA AA AA


Thank's
A

as an option

Please Login or Register  to view this content.

Hi ,

Thanks for the help , however its giving me error "Subscript out of range".

Thanks,
A

Ohh.. option sent by nelim worked for me perfectly


thank you so much both of you ......

Hi

Have tried that as well, unfortunately it didn't worked for me, i am new to VBA may be because of that, i could not handled it properly.

Thanks for helping me....

Dear Nliem ,

option that you have provided to me is awesome, however while working on file i understand that it only take 252 rows in consideration , till 252 rows it works perfectly fine, but if i have more than 252 rows it gives me error "method 'range of object' Global failed

can you pls help ??

Thanks,
A

try

Please Login or Register  to view this content.

No words !!!!! it worked for me fantastically ........


thank you so much for your help

hi mikerickson,

i apply your code & keep for my knowledge.

Thanks,
A