Worksheet_Change Event

Hi there

I am using the following code in a sheet called "Centre"

Private Sub Worksheet_SelectionChange(ByVal Target As Range)


If Target = ("D2") Then




    Sheets("Consolidated").Activate
    Range("D2").Activate
    ActiveCell.Value = Sheets("Centre").Range("D2").Value
End If
End Sub

This code does not do what I thought it would, (Change the "Consolidated" sheet to that of the "Centre" sheet)

Cell D2 has a LIST Data Validation, and the idea is that the corresponding cell in sheets "CONSOLIDATED" also says the same as Centre!D2.

I know I could use a simple = in the consolidated sheet, but Consolidated!D2 also has a Data Validation of List.

I need the Consolidated to be the same as Centre, but with the option to change.

Hope that makes sense and someone can show me the error.

Thanks

Re: Worksheet_Change Event

Hi All

After a bit more browsing, I found this:
http://www.mrexcel.com/forum/e…-class-failed-solved.html

and changed my code to:

Private Sub Worksheet_Change(ByVal Target As Range)


If Target.Address = "$D$2" Then




    Sheets("Consolidated").Range("D2").Value = Target.Value




End If




End Sub

Which has solved my problem.

Hope this helps others

Re: Worksheet_Change Event

I thought it would, hence why i used that in my original code, but nothing happened.

If Target.Address = "$D$2" Then

does work, so happy with that