If I write numbers in C4 sheet1 I want to copy

  • Thread starter Thread starter Dag Johansen
  • Start date Start date
D

Dag Johansen

If I write numbers in C4 sheet1 I want to copy all in raw
C sheet1 to sheet 11 raw C. If nothing is writed in C4
nothing should happend. Is this possible and if so how to
do it?


Please help


Dag Johansen
 
I assume when you said raw C that you meant COLUMN C.
right click on sheet tab>view code>insert this code>save workbook

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$C$4" Then Exit Sub
Columns("c").Copy [sheet11!c1]
End Sub
 
I got a error message "Run-time error 1004 application-
defined or object-defined error"

When I debug I get:"Columns("c4").Copy [sheet11!c1]" in
yellow.

Thanks

Dag
 
Back
Top