This is ideal if you wish to create a number of similar or identically structured worksheets. One of the key benefits of using the worksheet scope is the ability to clone a worksheet together with all the worksheet Defined Names. So why and when do we use Defined Names scoped to the worksheet? This is the default scope when defining names in Excel. Most of my Defined Names are scoped to the Workbook. Add Name : = myRangeName, RefersTo : = myNamedRange End Sub Choosing the Scope Defined name and cell range are as specified myWorksheet. Range ( "D1:E10" ) '// specify defined name myRangeName = "namedRangeWSscope" '// create named range with worksheet scope. Worksheets ( "Sheet1" ) Set myNamedRange = myWorksheet. Add Name : = myRangeName, RefersTo : = myNamedRange End Sub '= ' # Create a Named Range with Worksheet Scope '= Sub createNamedRangeWS () '// Vars Dim myWorksheet As Worksheet Dim myNamedRange As Range '// Declare vars Dim myRangeName As String '// identify ranges Set myWorksheet = ThisWorkbook. Defined name and cell range are as specified ThisWorkbook. Range ( "A1:C10" ) '// specify defined name myRangeName = "namedRangeWBscope" '// create named range with workbook scope. '= ' # Create a Named Range with Workbook Scope '= Sub createNamedRangeWB () '// Vars Dim myWorksheet As Worksheet Dim myNamedRange As Range '// Declare vars Dim myRangeName As String '// identify ranges Set myWorksheet = ThisWorkbook.
0 Comments
Leave a Reply. |