On 2002-10-24 11:45, tim963 wrote:
Can this be done without selecting sheet 2? Thanks
Sub Macro1()
Range("A2:A5").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A65536").Select
Selection.End(xlUp).Select
ActiveCell.Offset(1, 0).Select
ActiveSheet.Paste
End Sub
On 2002-10-24 12:52, maurizio.rota wrote:
Ok, but is it possible copy ONLY VALUES?