naming cells

D

Dave

i have the numbers 1 to 80 in a column of cells. i want to name these cells
num1, num2 ..... num80. is there an easier way to do this rather than
clicking on each cell and naming it in the name box? i notice that the
cop/paste function doesn't work for the name box. tia

Dave
 
B

Bob Umlas

enter num1 in an adjacent column, say your data is in A1:A80, place num1 in
B1. double-click the fill handle so you have num1 thru num80. Select A1:B80,
use Insert/Name/Create and choose "Right Column". When that's done, clear
column B and you're done.
Bob Umlas
Excel MVP
 
B

bigwheel

You could put it in a macro

For a = 1 To 80
ActiveWorkbook.Names.Add Name:="num" & a, RefersToR1C1:="=Sheet1!R"
& a & "C1"
Next a
 
Top