Forum Discussion

amitabhjain

Copper Contributor

Nov 13, 2019

Persistent tags in Excel

Is there any feature in excel to have persistent tag for ROW, COLUMN and CELL?

excel

amitabhjain

Copper Contributor

Nov 14, 2019

Celia_Alves Thanks for the quick reply. But I am not asking for same.

I was wondering if I can give a persistent property , I can use

Example - ID property of Cell. I can assign some thing.

Range("a1").Cells.ID = 1234

However if I close my workbook and open it. the value of ID is gone.

Celia_Alves

MVP

Nov 14, 2019

Would using a Name for the cell work for what you need? Google "how ro create names in Excel" and "how to use named ranges in Excel formulas".
Here is an example:
https://trumpexcel.com/named-ranges-in-excel/