Unique question...

[Chatterbagz]

Here's something that I cannot find any documentation on how to do.

I have a large number of non-contiguous cells that I need to name as
range. I do that, but I would like to move the selection marquee dow
1 row to name that range another name, and so on with the next rows.
(I don't want to copy or paste the data, I'm just talking about th
selection marquee)

How do I move the selection marquee ? I do not want to have to g
through each row and select these certain cells just to name tha
range.

Any ideas

 

[Bob Umlas]

Use vba:
Selection.offset(1).select

 

[Alan Beban]

Sub runranges()
Set rng = Range("A1,b2,c3,h1,k4")
rng.Name = "Name1"
Set rng2 = rng.Offset(1, 0)
rng2.Name = "Name2"
Debug.Print "Name1", rng.Address
Debug.Print "Name2", rng2.Address
End Sub

Alan Beban

 

[Chatterbagz]

Sweeet. Thanks you guys