Writing a routine to name a dynamic range

Must be a simple solution... I "simply" don't see it

The following routine should delete a named range called "Sort"from the active workbook and select an area of the active worksheet which could change with different users. Then, re-create the named range "sort"using the selection.
As one can see, the range for the previously named range "sort", is not a variable in the active name call... this is the problem.... I need to learn a strategy that will convert the current selected range into a variable that can be used in the "add name" call.

Once again, thanks in advance for your effort.

Please Login or Register  to view this content.

Perhaps:

names.Add Name:="Sort", Refersto:=Range("A5").CurrentRegion

(The one line replaces all)

Very Elegant... I've been working too hard to learn the calls, functions and syntax... I found the library calls reference...but it's not intuitive enough for me... is there a better reference source for VBA?

Very Elegant... I've been working too hard to learn the calls, functions and syntax... I found the library calls reference...but it's not intuitive enough for me... is there a better reference source for VBA?

Would be native-Excel dynamic range definition not work for you? Using the offset formula might do just that. Good Luck