Copy range in string.

[Vagelisr]

Hi to all.
I would like to know if it is possible to copy a range in a string and after paste the string in a excel sheet.
This is the range i need to copy......

        Set rHdr = Range("A" & i & ":" & "P" & i)
        Set rDtl = Range("A" & i & ":" & "K" & i)
        Set r0 = Range("Q" & i & ":" & "AT" & i)
        Set r1 = Range("Q" & i & ":" & "S" & i)
        Set r2 = Range("T" & i & ":" & "V" & i)
        Set r3 = Range("W" & i & ":" & "Y" & i)
        Set r4 = Range("Z" & i & ":" & "AB" & i)
        Set r5 = Range("AC" & i & ":" & "AE" & i)
        Set r6 = Range("AF" & i & ":" & "AH" & i)
        Set r7 = Range("AI" & i & ":" & "AK" & i)
        Set r8 = Range("AL" & i & ":" & "AN" & i)
        Set r9 = Range("AO" & i & ":" & "AQ" & i)
        Set r10 = Range("AR" & i & ":" & "AT" & i)

The reason is i need to check some specific cells and copy them in another excel file.....

Thanks and regards

 

[Oscar Cronquist]

Do you want to concatenate the values and then paste the result into one single cell?

 

[Vagelisr]

Hi Oscar and thanks for your time.
No. I want to paste it into all the cells I've copied.
If I've copied 10 cells in, I want when I'm paste it "catch" 10 cells again.

Thanks and sorry for my English