copying cells
 

Hi Erik,

See reponses i n your other thread.


---
Regards,
Norman



"Erik" wrote in message
...
I am currently using the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
'Copy the cells
With Worksheets("Sheet2").Range(Target.Address)
.Value = Target.Value
End With
End Sub
This copies all cells from sheet1 to sheet2. How can I modify this to
copy just a specified range of cells?
Erk