Dynamic named ranges

Hi Nicole

The following procedure dynamically assesses the extent of an excel table, assigns that range to a range object and then names that range.
Every time the code is run, the range updates dynamically

Sub DynamicRanges()





    Dim rngDynRng As Range

    

    

    Set rngDynRng = Sheets("Data Validations").Range(Cells(3, 1), _

        Cells(Range("A3").CurrentRegion.Rows.Count, Range("A3").CurrentRegion.Columns.Count))

        

    rngDynRng.Name = "MyTable"

    

    



End Sub

Hope this is what you were looking for

Regards

Stephen