How can I assign a new range to a named range with VBA?

[vbaNumpty]

For instance I have a named range called DashboardSumm, how could I use a line in VBA to set it's reference range to :

=Dashboard!$B$3:$P$2322

before then using macros to effect changes on that named range?

 

[vbaNumpty]

For anyone who comes across this:

ActiveWorkbook.Names.Item("YourNamedRange").RefersTo = "=Sheet#!RANGE"