Billy, if it is in the same workbook it will look like below. Lets
assume you have copied the data on sheet1 range A1:F30 and want to paste
it in sheet2 range C4 the macro looks like this:


Code:
--------------------

Sub copy_to_sheet()
Range("A1:F30").Select
Selection.Copy
With Sheets("Sheet2").Range("C4")
.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End With
Application.CutCopyMode = False
End Sub

--------------------


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=34846