Naming Cells - need help

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Naming non-contigent cells with vba 5
Named cells in an array to a column and to a row 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Counting Criteria Values with For Loop 3
Dynamic Named Cell 1
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Need urgent help 0

Back
Top