J Jo Aug 20, 2003 #1 Hi Can anyone give me an example of looping cells though a named range. Thanks Jo
H Hank Scorpio Aug 20, 2003 #2 Hi Can anyone give me an example of looping cells though a named range. Thanks Jo Click to expand... In the example below, MyRange is a range name defined as =Sheet1!$A$1:$A$11 Sub LoopThroughRange() Dim rng As Excel.Range For Each rng In ActiveSheet.Range("myrange") Debug.Print rng.Value Next End Sub
Hi Can anyone give me an example of looping cells though a named range. Thanks Jo Click to expand... In the example below, MyRange is a range name defined as =Sheet1!$A$1:$A$11 Sub LoopThroughRange() Dim rng As Excel.Range For Each rng In ActiveSheet.Range("myrange") Debug.Print rng.Value Next End Sub
