EASY Naming a Range of cells

  • I can not figure out how to simply name a range of cells in my assignment. We have to write our own vba code, otherwise i know how to name it through excel. No online links help either. How can I name cells A1:G8 as "GRADES" ? I know it's simple but I have not got it yet.

  • Hello and Welcome to the Forum :)

    You could test the following

    Sub AddRangeName()
        ActiveWorkbook.Names.Add Name:="GRADES", RefersTo:="=Sheet1!A1:G8"
    End Sub

    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Hi wendyl

    Try this:

    Sub Name_Area()
        ActiveWorkbook.Names.Add Name:="GRADES", RefersToR1C1:="=Sheet1!R1C1:R8C7"
    End Sub

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!