xlCopy in worksheet event

[Tsjaikovski]

Hi,

I was wondering if it's possible that when a range:e5 is copied to a range:e9 that a worksheet change makro copies the complete row 5 to row 9.

Thx for helping me out,
Tsjai

 

[rs2k]

Will this work for you?

Sub CopyLine()
    Range("E5").Select
    Range(Selection, Selection.End(xlToRight)).Copy Destination:=Range("E9")
End Sub

HTH
Colin

 

[Tsjaikovski]

Hi the problem is that I want this code to be executed in a worksheet change event and once I paste the value to eg e9, excel doesn't now anymore the adress of the cell that it has been copied from (eg e5).