Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Generate Range object from named range

Sub BuildRangeFromName()   Dim rng As Range   Set rng = Evaluate(ActiveWorkbook.names("NameArea").Value)   Debug.Print rng.Address(External:=True) End Sub