Thanks Duke Carey for replying!
Insert-Name-Apply would apply the row names (rowName) to the rows (first
row) only. Insert-Name-Apply does not apply the row names (rowName) instead
of the single cell references like D1000 =D1 in my example.
There is about a thousand such names on the sheet.
Please, help!
Regards,
Dmitry
"Duke Carey" wrote:

Insert-Name-Apply

That may require you to go through each range name, one at a time, though.

If so, you could

"Dima" wrote:

Hello!
How to replace thousands of single cell references (for example, A1) with
row names? The formulas and its precidents are in a same column.
For example:
row name: rowName = $1:$1
The formula in D1000 =D1
How to replace =D1 with =rowName in cell D1000 automatically?
There are thousands cells like D1000 and row names like the rowName.
Regards,
Dmitry

"Duke Carey" wrote:

Dmitry -

Several of your questions have been short, general, and vague to the point
of not posing a question that can be answered. Please provide better detail
and explanation of what you are trying to do.


"Dima" wrote:

Hello!
How to appy a thousand new range names to formulas which use corresponding
single cells in the ranges?
Regards,
Dmitry