cells b2:b6=wk1, b7:b13=wk2 etc
 

want to name cells b2:b6=wk1, b7:b13=wk2 etc

cells b2:b6=wk1, b7:b13=wk2 etc
 

Consistency????
6-2=4 2-6=5
13-7=6 7-13=7


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Excel problem" <Excel wrote in message
...
want to name cells b2:b6=wk1, b7:b13=wk2 etc

cells b2:b6=wk1, b7:b13=wk2 etc
 

Name as in InsertNameDefine?

If not too many of these, select B2:B6 and name that range wk1

If you want 52 wks named then VBA would be faster.

BUT.........I notice no pattern from your example.

wk1 is 5 cells while wk2 is 7 cells.


Gord Dibben MS Excel MVP

On Tue, 2 Jun 2009 15:24:01 -0700, Excel problem <Excel
wrote:

want to name cells b2:b6=wk1, b7:b13=wk2 etc