To add a range name for known range : Range Add « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Range Add

To add a range name for known range

 
Sub AddName1()
   ActiveSheet.Names.Add Name:="MyRange1", RefersTo:="=$A$1:$B$10"
End Sub








Related examples in the same category

1.To add a range name based on a selection
2.Use ActiveCell and ActiveCell.End to create Range
3.To add a range name based on a selection using a variable