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

3 Replies

  • 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