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,