Named Ranges - Resizing How? (Excel,VBA)

[Beldrueger]

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

[Beldrueger]

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

Dim nme As Name 

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

set nme = nothing