Hi folks,

I have the following target:
I got a macro in sheet 1, which I want to trigger after a change in sheet 2.

My idea to do this is my a sub in sheet 2:

Private Sub Worksheet_Change(ByVal Target As Range)
Call Markmacro
End Sub

Which is referring to:

Sub Markmacro()

Range("D3:E3").Select
Selection.Copy
lMaxRows = Cells(Rows.Count, "G").End(xlUp).Row
Range("G" & lMaxRows + 1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

End Sub

If I place the last sub in a module it works, only it works in sheet 2 i.s.o. sheet 1.

Googling my issues directed me to multiple forums on this topic which offer this solution:

Private Sub Worksheet_Change(ByVal Target As Range)
Call Sheet1.Markmacro
End Sub

Somehow the sheet1. additive is not working (run-time error 1004, application defined or object defined error).

I know my mistake is probably very stupid, which is frustrating me enormous.

Thanks in advance for any help,

Cheers 'n Beers - Mark