Hi all,

I have data in A2, then blank till A18 (variable number each time), then data in A19 and blank till A35 (and more and more).

Using VBA how would I code to copy A1 into every cell till A18, then copy A19 into every cell till A35 and so on.

Perhaps using SpecialCells(xlTypeConstant) or something?

Thanks in adance

Seamus