Auto Calculate - VBA

[jwgreen1986]

does anyone know the VBA code to recalculate a sheet when a change to a drop down is made?
i have a huge amount of calculations in other worksheets so dont want to turn on the automatic workbook calculation. I need one sheet to auto calculate though when a change is made to the drop down.

 

[Scott T]

Try

Change E4 to where you drop down is and the sheet names to match your sheet names

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("E4")) Is Nothing Then
    Sheets("Sheet2").Calculate
End If
 
End Sub