C
Chris
I'm trying to use a macro ran from a button press to set the cell name
(label) for a set of cells.
This used to work before but now I'm getting "That name is not valid"
Googling it I don't find anything that really applies to me. The name
I'm trying to set is
r3rsadobe0000161099016701040
in Row 13, Cell 5
Here is the code that performs this.
Worksheets(newEvalArr(i)).Names.Add Name:=evalName,
RefersToR1C1:=cellInR1C1
where evalName is the above text and cellInR1C1 is "=R13C5"
The workbook is not corrupted (to the best of my knowledge) and I have
successfully inserted names around that length before, so I don't know
what's up.
(label) for a set of cells.
This used to work before but now I'm getting "That name is not valid"
Googling it I don't find anything that really applies to me. The name
I'm trying to set is
r3rsadobe0000161099016701040
in Row 13, Cell 5
Here is the code that performs this.
Worksheets(newEvalArr(i)).Names.Add Name:=evalName,
RefersToR1C1:=cellInR1C1
where evalName is the above text and cellInR1C1 is "=R13C5"
The workbook is not corrupted (to the best of my knowledge) and I have
successfully inserted names around that length before, so I don't know
what's up.