Pasting rows using variables in VBA

[rdw72777]

If I want to copy and paste rows of data using variables I'm having a brain fart, and the search function is giving me too many posts when I search on this topic.

I have variables i, j and k.

I want to copy row i and paste it in rows j through k. I can get the initial copy on one range (i.e. Rows(i).copy) but the paste syntax is confusing me. Wish I had my vba books at work but can someone post this for me, I know its quick and easy and I feel borderling dumb for not being able to get this....

 

[VoG]

Try

Rows(i).Copy Destination:=Rows(j & ":" & k)

 

[rdw72777]

Works in my test file, will put it in my production file and hopefulyl away I go.

Thanks!