Named Ranges - Resizing How? (Excel,VBA)

How can i resize a named range in Excel.

I have several functions that refer to ranges, so that when I run my code I don't have to rewrite the functions to the cell if the size of the ranges change. ...... well that's the idea ... except I can't seem to figure out how to resize a named range

Nevermind ... after more intensive searching I found a rather old post with this helpful bit:

Code:

---

Dim nme As Name

Set nme = ActiveWorkbook.Names("test")
nme.RefersTo = "=Sheet1!$A$1:$C$3"

set nme = nothing

---