Hi
I tested the macro it it seemed to work fine for me. If I understand you correctly it should do the following:
1. As Cell A6 is blank it should copy the contents of Cell A5 into Cell A6.
2. As Cell A11 and A12 are blank then copy the contents of Cell A10 into Cells A11 and A12.
and so on..................
The macro will run for 1000 lines. So Cell A30 will be copied to Cells A31 through A1000.

If this is not what you want then please explain what you expect to happen and I will see what I can do.
Tony(OTPM)