Hello,

I have a group of cells (100 of them) that I need to name individually. The
name of the cells would be "Line1LP" through "Line100LP". in column A, I
numbered each cell.
cell A1 = 1
cell A2 = 2
|
v
cell A100 = 100

In column B, I need to name the cells based on name + the value of the
corresponding value in column A.

cell name B1 = line1lp
cell name b2 = line2lp
|
v
cell name b100 = line100lp

Is there a way to do this through vba or using a formula?

Thanks,

I do NOT recommend doing this!!! A macro can do this

for i=1 to cells(rows.count,1).end(xlup).row
cells(i,2).name="Line" & cells(i,1) & "LP"
next i

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Brad" wrote in message
...
Hello,

I have a group of cells (100 of them) that I need to name individually.
The
name of the cells would be "Line1LP" through "Line100LP". in column A, I
numbered each cell.
cell A1 = 1
cell A2 = 2
|
v
cell A100 = 100

In column B, I need to name the cells based on name + the value of the
corresponding value in column A.

cell name B1 = line1lp
cell name b2 = line2lp
|
v
cell name b100 = line100lp

Is there a way to do this through vba or using a formula?

Thanks,