How do i loop through cells in my named ranges

[Sahil123]

Hi All,

I have 3 named ranges in my sheet

How do i loop through each cell in those named ranges

For cell in ????
Cell.select
Next Cell

and how can i also set it up as a variable as an alternative i.e

Arr = Range("A","B","C")

For each cell in Arr
Cell.select
Next Cell

Thanks

 

[Sahil123]

Hi All,

I have 3 named ranges in my sheet

How do i loop through each cell in those named ranges

For cell in ????
Cell.select
Next Cell

and how can i also set it up as a variable as an alternative i.e

Arr = Range("A","B","C")

For each cell in Arr
Cell.select
Next Cell

Thanks

Bump anyone

Thank You So Much

 

[Jonmo1]

Assuming you have valid named ranges named A B and C
Although I don't think C is a valid name, it's short for Column..
But I assume A B and C are just simple examples..

This should work

Set Arr = Range("A, B, C")
 
For Each Cell In Arr
    Cell.Select
Next Cell

 

[Sahil123]

Assuming you have valid named ranges named A B and C
Although I don't think C is a valid name, it's short for Column..
But I assume A B and C are just simple examples..

This should work

Set Arr = Range("A, B, C")
 
For Each Cell In Arr
    Cell.Select
Next Cell

Thank You

Yep they were just used to show as an example

Waht if i named them in my spreadsheet

how would i reference them in my for each loop?

Would i need to define it in a variable or could i omit that and do something like

For each cell in (Named ranges)??
Next cell


Thanks

 

[Jonmo1]

That's what I just showed.

If you have valid named ranges, say
rng1 = A1:A10
rng2 = E1:E20
rng3 = G10:J30

Then this will loop through ALL of those cells

Set Arr = Range("rng1, rng2, rng3")
 
For Each Cell In Arr
    Cell.Select
Next Cell