make all data sets in different rows

**johncena** · 07-05-2010, 04:34 AM

dear friends in my document column "B" has different sets of data.first row has document header.that each sets should start with row 7,12,17,22,etc...
for that i have tried below macro & it's work very well.only the problem is this macro rows counting start from first row.but i want to change it to second row.(first row has header) pls help me how i can i do it......

Please Login or Register  to view this content.

**snb** · 07-05-2010, 05:30 AM

Don't use select or activate in VBA.

Please Login or Register  to view this content.

**johncena** · 07-05-2010, 05:56 AM

Originally Posted by snb

Don't use select or activate in VBA.

Please Login or Register  to view this content.

thanks for your reply but this not work for me.macro should run base on column "B".pls help me..

**snb** · 07-05-2010, 06:54 AM

Did you try to read the code I gave ?
Did you analyse it ?
Do you know what usedrange means ?

**johncena** · 07-05-2010, 07:07 AM

Originally Posted by snb

Did you try to read the code I gave ?
Did you analyse it ?
Do you know what usedrange means ?

i have attached sample sheet.pls check it.my problem is as a my sample sheet second set should start with row # 7.but my macro it's starting with row # 6.pls help me,..