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.
Dim TeamRng As Range
Set TeamRng = Range("A4:C25")
Selection.Copy Destination:=Sheets("RegionQualifiers").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)