Copy and paste range values only

  • I have some code that copies and pastes a range ("A4:C25") from the active sheet to another and it works well. However, it copies the cell formatting such as cell colour. I would like to copy only the cell contents without the formatting. Any help would be appreciated.


    [VB]
    Dim TeamRng As Range
    Set TeamRng = Range("A4:C25")
    TeamRng.Select
    Selection.Copy Destination:=Sheets("RegionQualifiers").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
    [/VB]

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • Re: Copy and paste range values only.


    Worked like a charm. Thank you so much.

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • Re: Copy and paste range values only


    Thank you for letting me know. Is there anything that I should do to the threads after a solution has been found?

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.