Copy/Paste Range

[mastermind]

I have a range (E1095) and I would like to have excel copy it and
paste the values in a range of identical size (U10:AF95). Can someone
please tell me how to do this.

I have tried using these codes:

Range("E1095").Copy
Range("U10:AF95").Paste

Range("E1095").Select
Selection.Copy
Range("U10:AF95").Select
Selection.Paste

Neither one works for whatever reason, and cause my macro to skip
sections. Does anyone know how to solve this problem? Any help would
be appreciated. Thank you.

 

[Gary Keramidas]

should be all you need, but qualify the range with the sheet names

Range("E1095").Copy Range("U10")

or
Worksheets("sheet1").Range("E1095").Copy Worksheets("sheet1").Range("U10")

 

[Bernard Liengme]

When you do a Copy & Paste (without VBA), you select only one cell before
the Paste operation.
I recorded a macro as I did a Copy&Paste; this is what I got
Sub Macro1()
'' Macro1 Macro
' Macro recorded 22/12/2006 by Bernard V Liengme
Range("B2:B5").Select
Selection.Copy
Range("J2").Select '<<<<<< Note only one
cell is selected
ActiveSheet.Paste
End Sub

best wishes and Merry Christmas