naming cells
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
"Dave" wrote:
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
|