Recalculate Range Name After Change

[soteman2005]

Hi,

I would like to create a macro that automatically runs to recalculate the named range "DC_subscriber_average" when anything on the sheet "Demand-Inputs" changes. I would be grateful if someone could point me in the right direction or write a quick macro for me.

Thanks

Adam

 

[BrianB]

rightclick sheet tab & View Code.
You do, of course have Calculation set to Manual otherwise this is unnecessary ?

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    ActiveSheet.Range("DC_subscriber_average").Calculate
End Sub