How to insert 2 rows between copied data

0
votes

I have to copy two data from sheet1 to sheet2. and i want to insert 2 rows between these copied data in sheet2. But i only know that each data can contains 50 elements. Iam stuck here. Anny idea ?

1
vbaexcel

1 Answers

1
votes

After copying the first set of data, copy the second set starting from Worksheets("sheet2").Range(Cells(Worksheets("sheet2").UsedRange.Rows.Count + 3, 1).Address).Select