Worksheet_SelectionChange not working in Excel 2016

    I have a file that takes the data from a row and puts it into a chart, if you select a different row you get a different chart.
    This works well in Excel 2007, we are changing to 2016 and the code is not working.
    I have looked through many posts but can't get the answer that works.
    I have tried

    Code
    Application.EnableEvents=True

    ...does not help.
    This is what I use:

    Code
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If ActiveCell.Row > 2 And ActiveCell.Row < 500 Then _
      ActiveSheet.Calculate
     End Sub


    Any suggestions?

    Re: Worksheet_SelectionChange not working in Excel 2016


    I just changed the word ActiveCell to Target and get the same result.

    Re: Worksheet_SelectionChange not working in Excel 2016


    I'm sorry about the code tags, I am very new to this.
    When I click on a cell the chart does not update as it does in Excel 2007

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login