Recalculate Named Range After Sheet Changes

[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

[Norman Jones]

Hi Soteman2005,

Try:

'=============>>
Private Sub Worksheet_Change(ByVal Target As Range)
Range("DC_subscriber_average").Calculate
End Sub
'<<============

This is worksheet event code and should be pasted into the Demand-Inputs
sheets's code module (not a standard module and not the workbook's
ThisWorkbook module):

*******************************************
Right-click the worksheet's tab

Select 'View Code' from the menu and paste the code.

Alt-F11 to return to Excel.
*******************************************

---
Regards,
Norman



"soteman2005" <soteman2005.1zklyy_1133792101.6198@excelforum-nospam.com>
wrote in message
news:soteman2005.1zklyy_1133792101.6198@excelforum-nospam.com...
>
> 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
>
>
> --
> soteman2005
> ------------------------------------------------------------------------
> soteman2005's Profile:
> http://www.excelforum.com/member.php...o&userid=29078
> View this thread: http://www.excelforum.com/showthread...hreadid=490728
>