Extending a Defined Excel Range

[Sforster]

Thanks for the response Paulw,

What I meant was that if I have a named range, Lets say Locations.

I want to count the number of rows in Locations and then add one to it and then re-define the range that Locations refers to.

Something like

Private Sub UpdateRange()
dim MRange as range, Mcount as byte

Set Mrange = Range("Locations")
Mcount = Mrange.rows.count

blah...blah..blah (off setting by one)

somehow save the named range locations 

end sub

If you get what I mean

thx

Steve