looping cells though a named range

H

Hank Scorpio

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VBA to Copy Ranges to a PreSet Dim formula AND Cell Propertys. 0
random range of cells via cell names 3
VBA for Dependents shortcut menu 0
Take active cell value in for loop and offset based on another cellvalue for columns to offset 0
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Curious string error in named range automation attempt - just doesn'tseem to make sense! 5
Code to Concat a row in loop 2
Need Help with a VBA subroutine 0

Top