Hi,
Try this by usinghelper colomn:
your data (names) is in column A
helper column=B
enter 1 in first row of column B and 2 in the second row of column B mark
Cells B1 and B2 copy drag down these 2 cells to end of your data in the next
down cell in column B enter 10 and in the next down cell enter 20, marrk 10
and 20 and copy drag down till you reach the number 1000, sort column A and B
based on column B.
it should work.
Thanks,
--
Farhad Hodjat
"Guy Lydig" wrote:
Excel XP
In column A I have a list of over 1,000 names. I want to insert a blank row
after every 10 names. There must be a simple way to do this in VB but I am
not familiar with VB.
If you can help, please be specific.
Thanks
Guy