Regarding naming ranges....

[Phil Smith]

Hi People of the Forum,

First of all, this is more of a "I wonder if..." question rather than a I REALLY need this to be solved situation.

Anyway, I have a table in which I need to name each row as a range, not a problem, I use:

For r= 2 to 71

    .Cells(r,2).Resize(1,28).Name="Week"&r-1

Next r

Is it possible to name each row in one batch? I was probably thinking along the lines of SpecialCells to act on all cells matching a given criteria (I think) and just wondered if it was possible to create/name multiple ranges in one go.

Probably not, but if you don't ask...

Thanks!

 

[pgc01]

Hi

You can if you have the names of the named ranges at one of the borders of the table.

For ex. in the case you posted, if you have the names in column A, like A2="Week1", A3="Week2", etc, you can use:

    Range("A2").Resize(70, 28).CreateNames Left:=True

 

[Phil Smith]

Thanks! I was not expecting it to be possible!

 

[pgc01]

You're welcome.