Forum Discussion

amitabhjain's avatar
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
Celia_Alves's avatar
Celia_Alves
MVP
Nov 13, 2019
$F$2 fixes both colum and row $F2 fixes the column and lets the row change when you drag the formula F$2 fixes the row and lets the column change when you drag the formula Is it this you were asking?
  • amitabhjain's avatar
    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.

     

Resources