Hi guys,
I was wondering if anyone could help me.

I have a dataset/array (A1:BZ199) that I need copied around 400 times, with a gap of one row between each dataset. I need the title from a different spreadsheet (sheet2) to appear in the cells A1, A201, A401.... ETC (The titles in sheet2 are from a1:a400)


If anyones wondering. This is what my code looks like so far;
Sub q
Dim myRange As Range
Dim last As Long, x As Long
Set myRange = Range("a8:bz200") 
For x = 1 To 400         
last = Cells(Rows.Count, "a").End(xlUp).Row
myRange.Copy Cells(last + 2, 1)

Next
End Sub
So this copies the dataset, but doesn't solve the title problem. Is this the way I should do it?

-thanks in advance.