Excel 2007 : How to create a loop with this code?

Hi All
I'm using this code to populate a list of 'names'
in to a new range where each 'name'/(cell) have 22 cells space between each other:

Please Login or Register  to view this content.

This is a very long list (avg' of 100 'names')
So I need to loop this action to have a better macro code
Also the macro must use the cell "A7" to get the number of loops.
(So if "A7" contains 76, the macro will loop for 76 times)

Any suggestions to how should I go with this?

Many thanks for your help,

Amit

hi furiousfox
something like

Please Login or Register  to view this content.

Nice, quick, smooth, perfect!

Thank you !!!

welcome, thanks for posting