Trying to Filldown

Hi, Trying to fill down in attached excel. Not sure what is the problem in line number 4 of code.The filling should be such that 111 should be till "d19 " and 2222 should be till "d29" and so on. But the code here goes one row above active cell which is not the desired result.

Please Login or Register  to view this content.

That worked. Thanks. Just trying to understand how does it paste without using any paste properties.

Just one more part i forgot. The last value in the row no 45 has to filled till some random cell. say in our example till row no 55

any help pls?

aavins73,
You can add a rand function using a formula in D55, no need for a code. I have added it in to the code, though, I do not know if this is what you want.

Please Login or Register  to view this content.