hello I am trying to define cells name by cells value I have tried activecell.name = activecell.value

[tahir573]

hello I am trying to define cells name by cells value I have tried activecell.name = activecell.value
but I want more than one cell to define I am trying selection.cells.name = selection.cells.value
I want every cell in selection sets it's name by it's value also i am trying to select a range and
define it's name by it's value please help me.

 

[jindon]

not sure

selection.name = selection.cells(1).value

 

[Richard Schollar]

If you want to name individual cells then you need to loop thru the cells:

For Each cell in Range("A1:A10")
  cell.Name = cell.Value
Next

Note that the above does not handle errors (eg caused by invalid names).

 

[jindon]

If you want name the multiple cell...

1) select then range
2) [Define name] - [Create from selection] - [left column]

 

[tahir573]

thanx jindon selection.cells(1).value works great to define a range name but i can't understand your second trick i am using excel 2002 and i can't see creat from selection any help by the way thanx again bro

 

[tahir573]

thanx richard it perfectly worked for me; i used " For Each cell In Selection " not range("a1:a10") thanx again bro

 

[tahir573]

thanx for jindon and richard they solved my problem i have 51 of cells and 24 ranges which i have to define a name for importing and exporting data from sheet to sheet well i am working on my project need regards from my seniors anyway thanx to richard and jindon keep it up bros