Code to paste in specific range

[kosherboy]

Hi.
This is my code

Please Login or Register  to view this content.

How do i make this part of the code refer to range A4:

Please Login or Register  to view this content.

I tried doing this:

Please Login or Register  to view this content.

but it didn't work.
Thanks.

[AB33]

Please Login or Register  to view this content.

[kosherboy]

Thanks.
The problem now is that A4 is the address for all the pasting of data so now the code keeps pasting over A4 and doesn't paste underneath it

[AB33]

Please Login or Register  to view this content.

[kosherboy]

Thanks again.
What is NR?
And the code is acting funny, it goes to row 300 start pasting going upwards then skips 100 rows??

[AB33]

I have commented the line

' If rCell Mod 2 = 1 Then

and used instead this line
If Application.IsOdd(rCell) Then
Please remove this line and use the commented row.
NR is just a long variable.

[kosherboy]

I'm afraid it's doing the same thing as before

[AB33]

I have not change anything to your code, except adding a single line

Please Login or Register  to view this content.

Or use one as suggested by Mike

Please Login or Register  to view this content.

[kosherboy]

It worked like a charm!
Thanks for not giving up