Quote:
Originally Posted by OTPM
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)
|
Yes. You are right. That is what I want. But when I tried it to copy the blank cells by dragging A5 Cell, it copies as follows:
CopyDataToCell-5
CopyDataToCell-6
CopyDataToCell-10
CopyDataToCell-11
CopyDataToCell-12
Actually it should copy:
CopyDataToCell-5
CopyDataToCell-5
CopyDataToCell-10
CopyDataToCell-10
CopyDataToCell-10
Where I am doing wrong in executing the function. Please help.
Thanks.