naming multiple ranges
I think your code is fine but some of your names may be illegal. For
instance "c" is not valid.
Run this modification to your first sub code instead and fix the bad names
that it points out after it runs.
Sub Macro()
Dim x As Range
On Error GoTo BadName
For Each x In Selection.Cells
x.Name = x.Text
NextCell:
Next
Exit Sub
BadName:
MsgBox "Cell " & x.Address & " has a bad name"
Resume NextCell
End Sub
--
Jim
wrote in message
...
I have tried many different codes and nothing will work. I have a 50 x
10 matrix of names and i want to name each cell in the matrix with the
text that is in the cell.
i have tried the following but get erros:
Sub Macro()
Dim x As Range
For Each x In Selection.Cells
x.Name = x.Text
Next
End Sub
sub macro()
For i=2 to 9
For j=3 to 52
cel=cells(j,i).text
ThisWorkbook.Names.Add Name:=cel _
RefersTo:=cells(j,i)
Next j
Next i
End sub
Any ideas?
|