Naming Cell Ranges

Hi Oliver

thank you for your question

First let me apologise for the delay in responding to your post

The following code programatically creates a name for a range of cells

Sub RangeName()



    Dim rngRange As Range

    

    

    Set rngRange = Range("a1:d42")

    

    

    rngRange.Name = "Test"

    

        

End Sub