This is the name we'll give to the range. The 'rangename' variable contains the MyRange value. We need to define the range name and the cells included in the range. In the above code, we first define four variables used to work with our named range. Set cell = Worksheets('Sheet1').Range(cellname)

The code below shows you how to create a named range using VB. You can also use VBA to add a named range to your workbook. If you should ever need to change the cell ranges for the given name, you can return to the Formula tab and click the Name Manager button. For most applications, you want the scope to be the entire Workbook, so you can reference the range regardless of the active worksheet.Ĭlick 'OK' when you're finished and open the VBE by pressing ALT+F11.

The scope is where you can reference the range. The dialog box also prompts you for a scope. We'll use this name in the next sections. For this example, name the range MyRange. A window opens where you can give the range a name. Click the Formulas tab and then click the 'Define Name' button. In your Excel spreadsheet, highlight a group of cells. Before you write any VBA code that references a named range, you must first give a set of cells a name. This name can then be used to manipulate cell data and formatting. In this article, we'll discuss cell ranges, referencing these ranges and then using different Visual Basic functions to control the range format and data. You either format the range, add data to it, or copy data from one location to the range of selected cells. When you use Excel, quite often you select a range of cells.

Visual basic for excel command list