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