Copy Paste

[dinesh shah]

Dear friends,

I want to copy values from cell a1, c1, f1, h1, j1 in sheet1 to cell a1, b1, c1,d1,e1 in sheet2.

Please help me with vba code for the same.

Thanks in advance

 

[Alex Blakenburg]

Something like this should work:

    Sheet1.Range("A1,C1,F1,H1,J1").Copy
    Sheet2.Range("A1").PasteSpecial Paste:=xlPasteValues

 

[dinesh shah]

Something like this should work:

    Sheet1.Range("A1,C1,F1,H1,J1").Copy
    Sheet2.Range("A1").PasteSpecial Paste:=xlPasteValues

Thank you Mr Alex

 

[Alex Blakenburg]

You're welcome. Glad I could help.